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

#bigquery #database