Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2025 07:08 AM
Hi @jorhona ,
This error happens because DLT marks deleted tables as "soft-deleted" in Unity Catalog, and they need to be restored to their original state before you can make changes.
To resolve this:
- Recover the misspelled schema and tables:
UNDROP SCHEMA catalog_name.<typo_schema>;
UNDROP TABLE catalog_name.<typo_schema>.table1; - Then drop them properly:
DROP TABLE catalog_name.<typo_schema>.table1;
DROP SCHEMA catalog_name.<typo_schema>;
Once that's done, you can rerun your pipeline using the corrected schema without hitting the soft-deletion issue.