When does a materialized view get suspended in Snowflake?

Question

Options

• AWhen a column is added to the base table
• BWhen a column is dropped from the base table
• CWhen a DML operation is run on the base table
• DWhen the base table is reclustered

• A
  6% (2)
• B
  91% (32)
• C
  3% (1)

Explanation

A materialized view in Snowflake gets suspended when structural changes that could impact the view's integrity are made to the base table, such as B. When a column is dropped from the base table. Dropping a column from the base table on which a materialized view is defined can invalidate the view's data, as the view might rely on the column that is being removed. To maintain data consistency and prevent the materialized view from serving stale or incorrect data, Snowflake automatically suspends the materialized view. Upon suspension, the materialized view does not reflect changes to the base table until it is refreshed or re-created. This ensures that only accurate and current data is presented to users querying the materialized view.

No community discussion yet for this question.