How does BigQuery store data?

How does BigQuery store data?

Partitioning docs -> https://goo.gle/3xXF4yE
Clustering docs -> https://goo.gle/3kGaRQR

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.

Timestamps:
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 -> https://goo.gle/2V0q7gj

Watch more episodes of BigQuery Spotlight -> https://goo.gle/BQSpotlight
Subscribe to Google Cloud Tech -> http://goo.gle/GoogleCloudTech

#BigQuerySpotlight

Product: BigQuery; fullname: Leigha Jarett;