How does BigQuery store data?

How does BigQuery store data?

Partitioning docs ->
Clustering docs ->

How does BigQuery’s internal storage work? In this episode of BigQuery Spotlight, we share how BigQuery stores data so you can make informed decisions on how to optimize your BigQuery storage. We’ll also talk about partitioning, as well as clustering and how it allows for efficient lookups.

0:00 - Intro
0:27 - Overview
0:50 - Columnar Storage
1:46 - Capacitor File Format
2:35 - Colossus Distributed File System
4:30 - Storage Optimization
5:00 - Partitioning
6:23 - Clustering
7:12 - Partitioning + Clustering

Storage optimization docs ->

Watch more episodes of BigQuery Spotlight ->
Subscribe to Google Cloud Tech ->


Product: BigQuery; fullname: Leigha Jarett;