'Materialized view and deleting the data of the connected table

My problem is about the updating scheme of Materialized View in Azure Synapse.

(Given: A materialized view is created using a table, I will be talking about these two only)

The question is: When I delete data from the table then will the Materialized view is also updated. (If YES then explain, and if NO then why is this important not to update the Materialized View)

azureviewazure-synapsematerialized-viewsazure-sqldw


Solution 1:[1]

REFRESH MATERIALIZED VIEW completely replaces the contents of a materialized view.

It is one of the benefits of Materialized view

  • Automatic and synchronous data refresh with data changes in base tables. No user action is required.

The database maintains data in materialized views by refreshing them after changes to the base tables.

Reference: Benefits of Materialized view

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 PratikLad-MT

Related Questions