Forum Discussion
Schematized source: when tables or columns are deleted in the source...?
Oh, I found this page, which I hadn't seen yet; it has a section about "How scans detect deleted assets"...
https://learn.microsoft.com/en-us/purview/concept-scans-and-ingestion
It actually seems like the intent is that an asset (database table) deleted in the source will be deleted from the Data Catalog. But maybe not right away, because "Deleted assets might continue to be visible in your catalog for some time before they are processed and removed." So it seems after more scans and more days, I should expect that my `table_x` will also disappear from Data Catalog, and the additional metadata we entered about it will be lost.
Which maybe isn't so bad; I can understand why that would be the intent. But again, it'd be nice to have a backup or something, in case I want to recover what was lost. But how?