Partitioning 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