Besides the table partitioning to improve performance and costs in BigQuery, there is also another technique available called clustering.
A little heads-up: Clustering and partitioning don’t preempt each other. And in most cases, it makes sense to use both in conjunction.
What are clustered tables?
Using clustered tables, BigQuery automatically organizes and colocates related…