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!
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 :)
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.
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.
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!
Thank you for explaining how this operates with the tables and capacitor file format
The video maybe contains an error at 1:35 - it says "OLTP" while it should probably say "OLAP" for Columnar Storage
Exactly.
Awesome explanation
Thanks for protecting my Data 🙏👍☺️
Ferrari = BigQuery in terms of Speed🔥
Anyone else noticed that she switched the places of the paintings in the background ?
thanks!
Awesome 👍👍
Does a Capacitor store a whole table in a columnar layout or does one capacitor store one column?
👍
partitioning is a condition to clustering...
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 :)
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.
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.