Clustering in BigQuery (Dynamic Filters & External Queries)

BigQuery is not like the other SQL languages in that one key thing does not exist... indexes!

Instead we have clustering to work with to improve not just peformance but cost.

BigQuery's pricing model is based on querying costs, and those querying costs are proportional to how much data is read in each query. As such a standard SELECT * FROM dataset.table can start to be very expensive when that table is reaching towards 100s of GBs. Using clustering to …

bigquery clustering cost costs data dynamic filters gcp key languages pricing queries sql work