3.1.2 - Partitioning and Clustering

Last updated Feb 5, 2025

🕓 Estimated time spent on this lesson | ~15 min

Youtube Video | ~8 min

https://www.youtube.com/watch?v=-CqXf7vhhDs&list=PL3MmuxUbc_hJed7dXYoJw8DoCuVHhGEQb&index=28

✍️ In this video we will learn more about partitioning and clustering and when to use one over the other.

❕You can cluster for up to 4 fields! Also, you will likely only want to do partitioning and clustering if data size is larger than 1 GB, otherwise it may actually be more costly and won't save time. BigQuery automatically reclusters the table as new data comes in.

If you use SQL server, here are some helpful resources

📚 MS SQL Server info

Partitioned tables and indexes - SQL Server, Azure SQL Database, Azure SQL Managed InstanceMicrosoftLearn

https://learn.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-ver16

📼 https://www.youtube.com/watch?v=Rxu3IenrMBI