topic Deleted Workspace leaves greyed out catalog in Data Governance

Deleted Workspace leaves greyed out catalog

ihenadb — Thu, 09 Jan 2025 11:09:17 GMT

Hi,

In our Azure tenant We have deleted a Unity Catalog registered workspace and ticked the Delete default workspace storage permanently

There are 2 catalogs that were created in that workspace that are now greyed out in the catalog explorer when access in another workspace .

In the catalog explorer there is now no workspace tab associated with these catalog, and it is not possible to change the ownership. In addition running (as metastore admin) SHOW CATALOGS; Does not return/list the catalogs.

Any ideas on how these can be removed / deleted ?

Thanks

Re: Deleted Workspace leaves greyed out catalog

Walter_C — Thu, 09 Jan 2025 12:48:31 GMT

Hello, thanks for reaching out, on this case you could try to delete the catalogs using the CLI command:

databricks unity-catalog catalogs delete --name my-catalog

For this you will need to be a Metastore admin.

Re: Deleted Workspace leaves greyed out catalog

Stefan-Koch — Thu, 09 Jan 2025 12:52:19 GMT

also try with the fore flag:

databricks unity-catalog catalogs delete --name my-catalog --force

Re: Deleted Workspace leaves greyed out catalog

ihenadb — Thu, 09 Jan 2025 15:50:01 GMT

databricks catalogs delete --name my-catalog --force

Thanks for the help ! Needed the force as the catalog was not empty. Also required a change of ownership of catalog to metastore owner.