BigQuery Table Clustering

TL;DR You should be using BigQuery Table Clustering

BigQuery has recently introduced the ability to independently cluster tables [GA ]. Up until now, the clustering feature was only usable when configured with table partitioning. Top level table clustering will provide additional performance enhancements for non-partitioned tables with autonomous table maintenance.

What is Table Clustering?

Clustering is one of several ways to physically design the layout of data in a BigQuery table. When data is written to a…