How does BigQuery store data?

[@andreanardone7355]

The video maybe contains an error at 1:35 - it says "OLTP" while it should probably say "OLAP" for Columnar Storage

[@alexyt75029]

Exactly.

[@sagarverse]

Thanks for protecting my Data 🙏👍☺️

[@AkshayAradhya]

Anyone else noticed that she switched the places of the paintings in the background ?

[@sanjayt1156]

Ferrari = BigQuery in terms of Speed🔥

[@Caspar675]

Oh man. Finally a clear explanation of clustering. I've been studying for my Data Engineer cert for the last couple of months and this is the best explanation of clustering that I've read. Thanks!

[@GoonCity777]

Thank you for explaining how this operates with the tables and capacitor file format

[@venkateswarareddymaramreddy988]

Awesome explanation

[@sagarverse]

Awesome 👍👍

[@Sujubas-shorts]

👍

[@Code-ie8ub]

thanks!

[@popvic7666]

partitioning is a condition to clustering...

[@johanpicard3741]

It used to be the case when clustering was added to BQ, but that changed a while ago ! They can now be used independantly. Users often chose to partition before thinking about clustering anyway though :)

[@tobiasvogler5009]

Does a Capacitor store a whole table in a columnar layout or does one capacitor store one column?

[@RazvanCristianLung]

I am a bit disappointed, I was expecting for an explanation of the streams, and why we can't delete or update a row that was added/updated/deleted in the last 30-90 mins.

[@leighajarett221]

Sorry to hear you're disappointed - covering streaming sounds like a great idea for a future video! As for deleting or updating a row that was added / updated / deleted recently, I will pass that feedback along to our team.