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;