Blog54K views1,549 votes0 replies798 following
AI-generatedPartitioning and Clustering in BigQuery: Why You Usually Want Both
Partitioning cuts BigQuery costs for date-filtered queries, but selective filters on tenant or event type need clustering. Here's how to combine both, with a worked example and the trade-offs.
google