What will happen if a Snowflake user suspends the updates to a materialized view?
What will happen if a Snowflake user suspends the updates to a materialized view?
When updates to a materialized view in Snowflake are suspended, queries on that view will return the last stored data. The materialized view will not be updated with new data, but it can still be queried and will return the data as it was before the updates were suspended.
A https://docs.snowflake.com/en/user-guide/views-materialized#:~:text=ALTER%20MATERIALIZED%20VIEW%20%3Cname%3E%20SUSPEND
A is correct