44.9K
NAWhy does everybody succeed with BigQuery and you are not?
Save $$$ THOUSANDS of dollars with these BigQuery optimizations: (most of them could be applied in your data warehouse as well or use analogy)
🔒 SAVE IT!
1️⃣ analyse query plan execution
2️⃣ avoid SELECT *
3️⃣ cluster your tables
4️⃣ partition your tables
5️⃣ apply filter with partitions on partitioned tables
6️⃣ reduce data before using a JOIN
7️⃣ for multiple joins start with the largest table
8️⃣ apply search index for faster string data search (cool BQ function)
What are your favourite cloud data warehouses tricks?
#sql #data #bigdata #datascience #dataanalyst #dataanalytics #dataengineer #datascientist #analytics
@nataindata
