Snowflake does not support Index, but it uses a clustering key to get the query performance. The clustering key is defined as the subset of externally appointed columns for co-locating the data in the table. This blog allows you to create the Clustering key.
Rather than creating or dropping the index in Snowflake, we can utilize the clustering key for achieving the query performance. For creating the clustering key, we use ALTER TABLE . CLUSTER BY command:
alter table table_name cluster by (column1, column2, …, columnN);
Cluster on a single column
alter table active_users1 cluster by (id1)
|Looking forward to a career in a cloud data warehousing domain? Check out the "Snowflake Training" and get certified today|
Cluster on multiple columns
alter table active_users1 cluster by (id1, active1)
But, we should be careful about using the clustering keys. The clustering key must be used only when we are handling tables of the below properties:
Clustering enables us to co-locate the data in similar micro-partitions. It is suitable for huge tables where the ordering is not good. I hope this article gives you adequate information about creating Clustering keys.
Snowflake Related Articles
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
|Snowflake Training||Dec 02 to Dec 17||View Details|
|Snowflake Training||Dec 05 to Dec 20||View Details|
|Snowflake Training||Dec 09 to Dec 24||View Details|
|Snowflake Training||Dec 12 to Dec 27||View Details|
Copyright © 2013 - 2023 MindMajix Technologies