
Explanation:
Based on Snowflake documentation and the community discussion consensus (with multiple upvoted comments confirming this), a materialized view becomes suspended when a column is dropped from the base table. This occurs even if the dropped column was not part of the materialized view definition. The other options are incorrect: adding a column (A) does not suspend the materialized view, DML operations (C) are normal operations that materialized views are designed to handle through incremental maintenance, and reclustering (D) is a background operation that doesn't affect materialized view status.
Under what conditions does a materialized view become suspended in Snowflake?
A
When a column is added to the base table
B
When a column is dropped from the base table
C
When a DML operation is run on the base table
D
When the base table is reclustered
No comments yet.