Lesson 06

How does bigquery clustering physically rearrange data blocks to speed up filtered queries

Name: How does bigquery clustering physically rearrange data blocks to speed up filtered queries
Uploaded: 2026-05-06T14:40:48.181Z
Duration: 3 min 17 s
Description: Without clustering, a table's Capacitor blocks are written in roughly insertion order. A query like WHERE customer_id = 'C123' has to scan every block, because C123's rows could be anywhere. Partition pruning helps if you partition by date, but you can only partition on one column, and only with limited cardinality (~10,000 partitions max). Clustering is how BigQuery prunes on additional columns.

Without clustering, a table's Capacitor blocks are written in roughly insertion order. A query like WHERE customer_id = 'C123' has to scan every block, because C123's rows could be anywhere. Partition pruning helps if you partition by date, but you can only partition on one column, and only with limited cardinality (~10,000 partitions max). Clustering is how BigQuery prunes on additional columns.

Get the full lesson

Take timestamped notes as you watch
Read the full transcript and download resources
Join the discussion and track your progress