Blog post → https://goo.gle/3iClDVr
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;
Duration: 00:08:20
Publisher: Google Cloud
You can watch this video also at the source.
