How to Drop an Index in Snowflake
As previously mentioned, Snowflake doesn't support the concept of indices.
As a substitute in particular situations, you can use clustering keys. Creation of clustering keys is explained here, and this article will show you how to drop a clustering key for a particular table.
To drop a clustering key, use the
ALTER TABLE .. DROP CLUSTERING KEY command:
-- syntax alter table table_name drop clustering key; alter table active_users drop clustering key;