Orphaned __dlt_materialization schemas left behind after dropping materialized views

sgreenuk
New Contributor

Hi everyone,

I’m seeing several internal schemas under the __databricks_internal catalog that were auto-created when I built a few materialized views in Databricks SQL. However, after dropping the materialized views, the schemas were not automatically deleted and they are still showing even though they have no table or view assocaited. I also cannot delete these as it says "System owned schema can't be deleted". 

Has anyone else seen these internal __dlt_materialization_schema_* entries remain after dropping materialized views? Do they eventually get cleaned up automatically, or does Databricks Support need to remove them manually from the metastore?

Thanks.