Delete unassigned catalogs

matthiasn
Databricks Partner

Hi everybody,

due to some not-so-optimal Infrastructure as code experiments with terraform I ended up a lot (triple digit) of catalogs in a metastore that are not assigned to any workspace and that i want to delete.

Unfortunately, there is no way to even list those catalogs using the API. You only can list catalogs that are assigned to workspace. If I could create a list of the catalogs I could assign those to a workspace and delete those catalogs.

Am i missing something on "list all catalog, regardless if assigned to a workspace or not"?

(i am metastore admin and account admin, so no problem regarding access)