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;