✍️ 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
