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?
you can find metadata changes (e.g., creation of new entities, such as a materialized view) in the Journal