SP_6721
Honored Contributor II

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:

  1. Recover the misspelled schema and tables:
    UNDROP SCHEMA catalog_name.<typo_schema>;
    UNDROP TABLE catalog_name.<typo_schema>.table1;
  2. 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.