Are materialized views clusterable in Snowflake in the same way as base tables?

• A. Yes, you can cluster materialized views just like tables
• B. No, materialized views cannot be clustered
• C. Yes, but only if they are refreshed
• D. Only with a special configuration

Answer: (A)

Clustering is about how data is physically organized to speed up pruning during queries. A materialized view stores a precomputed result set as its own physical object, so it behaves like a regular table in terms of storage and how data can be laid out. You can define a clustering key on a materialized view (just as you would on a table) to control how its data is partitioned into micro-partitions. When queries filter on the clustered columns, Snowflake can prune more efficiently, improving performance even though the view is precomputed. The refresh mechanism of the MV doesn’t prevent clustering, and you don’t need a special configuration beyond specifying the clustering key (with optional automatic clustering if you want Snowflake to maintain it for you). So materialized views can be clustered just like base tables.