How does BigQuery store data?

Google Cloud Tech July 22, 2021
Video Thumbnail

About

No channel description available.

Video Description

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 → https://goo.gle/GoogleCloudTech #BigQuerySpotlight product: Cloud - Data Analytics - BigQuery; re_ty: Publish;

You May Also Like

Upgrade Your Gaming Audio Today

AI-recommended products based on this video

Loading...
HyperX CloudX Stinger 2 Core - Gaming Headset for Xbox, Lightweight Over-Ear headsets with mic, Swivel-to-Mute Function, 40mm Drivers - White

HyperX CloudX Stinger 2 Core - Gaming Headset for Xbox, Lightweight Over-Ear headsets with mic, Swivel-to-Mute Function, 40mm Drivers - White

(5,595)
$44.99
PrimeFREE delivery Sat, Jun 14
Loading...
NEW SteelSeries Arctis Nova 3 Multi-Platform Gaming Headset - Signature Arctis Sound - ClearCast Gen 2 Mic - PC, PS5/PS4, Xbox Series X|S, Switch, Mobile

NEW SteelSeries Arctis Nova 3 Multi-Platform Gaming Headset - Signature Arctis Sound - ClearCast Gen 2 Mic - PC, PS5/PS4, Xbox Series X|S, Switch, Mobile

(9,500)
$99.98$67.37
PrimeFREE delivery Sat, Jun 14
100+ bought in past month
Loading...
New SteelSeries Arctis Nova Pro for Xbox Multi-System Gaming Headset - Premium Hi-Fi Drivers - Hi-Res Audio - 360° Spatial - GameDAC Gen 2 - Quad-DAC - ClearCast Gen 2 Mic - Xbox, PC, PS5/PS4, Switch

New SteelSeries Arctis Nova Pro for Xbox Multi-System Gaming Headset - Premium Hi-Fi Drivers - Hi-Res Audio - 360° Spatial - GameDAC Gen 2 - Quad-DAC - ClearCast Gen 2 Mic - Xbox, PC, PS5/PS4, Switch

(517)
$209.41$122.65
PrimeFREE delivery Sat, Jun 14
Loading...
Razer BlackShark V2 X Gaming Headset: 50mm Drivers - Cardioid Mic - Memory Foam Cushion - Lightweight- Comfortable, Noise Isolating Earcups - for PC, PS4, PS5, Switch - 3.5mm Audio Jack - Black ECOLOGO

Razer BlackShark V2 X Gaming Headset: 50mm Drivers - Cardioid Mic - Memory Foam Cushion - Lightweight- Comfortable, Noise Isolating Earcups - for PC, PS4, PS5, Switch - 3.5mm Audio Jack - Black ECOLOGO

(17,449)
$54.98$48.21
FREE delivery Mon, Jan 26
3K+ bought in past month
Loading...
230W Charger Compatible with Razer Blade 14” 15” 16" 17” (2025-2018) RZ09 RTX-3060/3070/3080/4060/4070 Gaming Laptop RC30-0530 RC30-0238 RC30-0248 Replacement Power Adapter

230W Charger Compatible with Razer Blade 14” 15” 16" 17” (2025-2018) RZ09 RTX-3060/3070/3080/4060/4070 Gaming Laptop RC30-0530 RC30-0238 RC30-0248 Replacement Power Adapter

(16)
$67.99
FREE delivery Mon, Feb 16
Loading...
HyperX Cloud II - Gaming Headset, 7.1 Surround Sound, Memory Foam Ear Pads, Durable Aluminum Frame, Detachable Microphone, Works with PC, PS5, PS4, Xbox Series X|S, Xbox One – Red

HyperX Cloud II - Gaming Headset, 7.1 Surround Sound, Memory Foam Ear Pads, Durable Aluminum Frame, Detachable Microphone, Works with PC, PS5, PS4, Xbox Series X|S, Xbox One – Red

(73,207)
$89.99
FREE delivery Thu, Aug 21
500+ bought in past month
Loading...
New SteelSeries Arctis Nova Pro for Xbox Multi-System Gaming Headset - Premium Hi-Fi Drivers - Hi-Res Audio - 360° Spatial - GameDAC Gen 2 - Quad-DAC - ClearCast Gen 2 Mic - Xbox, PC, PS5/PS4, Switch

New SteelSeries Arctis Nova Pro for Xbox Multi-System Gaming Headset - Premium Hi-Fi Drivers - Hi-Res Audio - 360° Spatial - GameDAC Gen 2 - Quad-DAC - ClearCast Gen 2 Mic - Xbox, PC, PS5/PS4, Switch

(517)
$209.41$122.65
PrimeFREE delivery Sat, Jun 14
Loading...
Asus ROG Delta II Wireless Gaming Headset with Detachable Mic – Tri-Mode (BT, 2.4GHz, 3.5mm), 50mm Titanium-Plated Drivers, 110Hr Battery, Lightweight, for PC, PS5, PS4, Xbox, Switch, Mobile - Black

Asus ROG Delta II Wireless Gaming Headset with Detachable Mic – Tri-Mode (BT, 2.4GHz, 3.5mm), 50mm Titanium-Plated Drivers, 110Hr Battery, Lightweight, for PC, PS5, PS4, Xbox, Switch, Mobile - Black

(180)
$249.99$166.60
FREE delivery Sat, Jan 3
50+ bought in past month
Loading...
HyperX CloudX Stinger 2 Core - Gaming Headset for Xbox, Lightweight Over-Ear headsets with mic, Swivel-to-Mute Function, 40mm Drivers - White

HyperX CloudX Stinger 2 Core - Gaming Headset for Xbox, Lightweight Over-Ear headsets with mic, Swivel-to-Mute Function, 40mm Drivers - White

(5,595)
$44.99
PrimeFREE delivery Sat, Jun 14
Loading...
Ozeino Wireless Gaming Headset for Ps5, Ps4, Switch, Ultra Stable 2.4GHz USB & Type-C, Bluetooth 5.3 Gaming Headphones with Flip Mic, 40+Hr Battery Gamer Headset for PC, Laptop, Mobile, Mac(White)
Best Seller

Ozeino Wireless Gaming Headset for Ps5, Ps4, Switch, Ultra Stable 2.4GHz USB & Type-C, Bluetooth 5.3 Gaming Headphones with Flip Mic, 40+Hr Battery Gamer Headset for PC, Laptop, Mobile, Mac(White)

(478)
$40.36
500+ bought in past month
Loading...
BINNUNE Gaming Headset with Microphone for Xbox Series X|S Xbox1 PS4 PS5 PC, Gamer Headphones with Mic Casque for Xbox 1
Best Seller

BINNUNE Gaming Headset with Microphone for Xbox Series X|S Xbox1 PS4 PS5 PC, Gamer Headphones with Mic Casque for Xbox 1

(1,180)
$35.99
PrimeFREE delivery Sat, Jun 14
200+ bought in past month
Loading...
Asus ROG Delta II Wireless Gaming Headset with Detachable Mic – Tri-Mode (BT, 2.4GHz, 3.5mm), 50mm Titanium-Plated Drivers, 110Hr Battery, Lightweight, for PC, PS5, PS4, Xbox, Switch, Mobile - Black

Asus ROG Delta II Wireless Gaming Headset with Detachable Mic – Tri-Mode (BT, 2.4GHz, 3.5mm), 50mm Titanium-Plated Drivers, 110Hr Battery, Lightweight, for PC, PS5, PS4, Xbox, Switch, Mobile - Black

(180)
$249.99$166.60
FREE delivery Sat, Jan 3
50+ bought in past month
Loading...
Monster Mission 300 Wireless Gaming Headset, 2.4GHz/Bluetooth Gaming Headphones,Low Latency, Stereo, Audio Location Recognition, 48H Battery Life, Suitable for PS5, PC, PS4 and Other Gaming Devices

Monster Mission 300 Wireless Gaming Headset, 2.4GHz/Bluetooth Gaming Headphones,Low Latency, Stereo, Audio Location Recognition, 48H Battery Life, Suitable for PS5, PC, PS4 and Other Gaming Devices

(29)
$59.99
FREE delivery Sat, Sep 20
200+ bought in past month
Loading...
Logitech G435 Lightspeed and Bluetooth Wireless Gaming Headset - Lightweight Over-Ear Headphones, Built-in mics, 18h Battery, Compatible with Dolby Atmos, PC, Mobile - Black

Logitech G435 Lightspeed and Bluetooth Wireless Gaming Headset - Lightweight Over-Ear Headphones, Built-in mics, 18h Battery, Compatible with Dolby Atmos, PC, Mobile - Black

(14,873)
$49.99$39.99
FREE delivery Thu, Aug 21
400+ bought in past month
Loading...
RYR Wireless Gaming Headset for Xbox Series X|S, Xbox One, PS5, PS4, Mac, Bluetooth 5.3, 3D Surround Sound, Rotatable Earmuffs, Gaming Headphones with Noise Canceling Microphones-Blackgreen

RYR Wireless Gaming Headset for Xbox Series X|S, Xbox One, PS5, PS4, Mac, Bluetooth 5.3, 3D Surround Sound, Rotatable Earmuffs, Gaming Headphones with Noise Canceling Microphones-Blackgreen

(69)
$69.99
PrimeFREE delivery Sun, Jun 15
100+ bought in past month
Loading...
HyperX Cloud II - Gaming Headset, 7.1 Surround Sound, Memory Foam Ear Pads, Durable Aluminum Frame, Detachable Microphone, Works with PC, PS5, PS4, Xbox Series X|S, Xbox One – Red

HyperX Cloud II - Gaming Headset, 7.1 Surround Sound, Memory Foam Ear Pads, Durable Aluminum Frame, Detachable Microphone, Works with PC, PS5, PS4, Xbox Series X|S, Xbox One – Red

(73,207)
$89.99
FREE delivery Thu, Aug 21
500+ bought in past month
Loading...
2.4GHz Wireless Gaming Headsets for PS5, PS4, PC, Switch - Bluetooth 5.3 Gaming Headphones with Noise Canceling Mic, 7.1 Surround Sound, 70H Battery, Blue Lighting - White

2.4GHz Wireless Gaming Headsets for PS5, PS4, PC, Switch - Bluetooth 5.3 Gaming Headphones with Noise Canceling Mic, 7.1 Surround Sound, 70H Battery, Blue Lighting - White

(309)
$54.99
FREE delivery Sat, Nov 22
500+ bought in past month