CANNOT_ADD_TABLES_AFTER_SCHEMA_LOCATION_CHANGE error condition
Cannot add new tables to pipeline because the target schema's storage location has changed.
Schema '<schemaName>' now has storage location: <newStorageLocation>
New tables that cannot be created: <newTableNames>
Options to resolve:
- Remove the new table definitions from your pipeline
WITHOUT_KNOWN_ORIGINAL_LOCATION
- Migrate to the Default Publishing Mode (DPM) which supports location changes: https://docs.databricks.com/en/dlt/migrate-to-dpm.html
WITH_KNOWN_ORIGINAL_LOCATION
-
Revert the schema storage location to the original storage location for tables in the pipeline:
<originalStorageLocation> -
Migrate to the Default Publishing Mode (DPM) which supports location changes: https://docs.databricks.com/en/dlt/migrate-to-dpm.html