Core concept
Query filter on partition + cluster key → skip most data. 10-100x reduction typical.
Advertisement
How it works
Partition column choice matters. Cluster columns must be in leftmost prefix of common filters.
Advertisement
Trade-offs + gotchas
Every large BQ table. Reduces cost + latency dramatically. Design upfront.