Partitioning and Clustering with BigQuery

Any changes in loading data?

Simple and Clear explanation!

Impressive.. Thanks for sharing.

Thanks you for share us yours knowledge, Could you tell me how i can update de range of date on partition table?, my range date are between 2021-01-01 and 2021-08-30 but now i need the range date between 2021-09-01 and 2022-02-28. Thank you

is clustering same as adding index in regular table??

Hi ,can you please create a video on how to extract data to data warehouse by connecting to big query through Ssis

Great video! But video mentions that for choosing a clustering key or column, it should have high cardinality, but that's incorrect, ideally, the column should have,
- large enough number of distinct values to enable effective pruning on the table.
- small enough number of distinct values to allow Snowflake to effectively group rows in the same micro-partitions
for. eg you cannot have UUID field for clustering or a Gender field for clustering for a table.

first time ever I that understand a content created by Google. Congratulations for the way of explaining it.

thank!!!

Can clustering only be applied on 'Text' columns?

Very useful tutorial

You all are so funny and informative! You deserve an Oscar !

Thank for your video!

What are the limitations of partitions? That is, I can see PARTITION is used only when I apply a FILTER. Cant we make use of PARTITION PRUNING by JUST using JOINS without a actual FILTER?

Deserves an oscar, what a performance

Thanks for this video! I would know how to create family columns tables if I have to manage a table of more than 10K of columns? thank you

Excellent video, may be one of the clearest explanation about partitioning and clustering

Love it! Thanks for making these videos and please create more of these!

More (Firebase style) videos like these please :D

❤️ it!!

what is the difference between this and an index?

The Watch more Take5 episodes here links in the video descrpition going to some spam site.

Awesome guys..