azure-data-explorermaterialized-views

How to view what materialized views were removed in Azure Data Explorer?


I recently investigated a case involving a missing materialized view in our production environment. I ran the .show operations | where Operation == 'MaterializedViewDrop' command, which returned a lot of useful information — but it didn’t show which specific materialized view was deleted.

Is there any way to find out the exact materialized view that was dropped?


Solution

  • you can find metadata changes (e.g., creation of new entities, such as a materialized view) in the Journal