When does a materialized view get suspended in Snowflake?
When does a materialized view get suspended in Snowflake?
A materialized view gets suspended in Snowflake when a column is dropped from the base table. This is because the structure of the base table has been altered in a way that may impact the integrity and usability of the materialized view, necessitating its suspension to maintain consistency.
B ("If a base table is altered so that existing columns are changed or dropped, then all materialized views on that base table are suspended; the materialized views cannot be used or maintained. (This is true even if the modified or dropped column was not part of the materialized view.)")
https://docs.snowflake.com/en/user-guide/views-materialized#dropping-the-base-table
B is correct
B correct