azure-data-explorer

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


I recently investigated case about missing mat view at our prod env. I ran .show operations | where Operation == 'MaterializedViewDrop' command, and it shows lots of useful information, but missed what exactly materialized view was deleted.

Is there any way to find out what exactly mat view was dropped?


Solution

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