topic Metastore deletion issues in Administration & Architecture

Metastore deletion issues

mbanxp — Fri, 04 Jul 2025 09:45:17 GMT

Good afternoon,

I have an issue with my metastore in North Europe.

All my workspaces got detached:

If I go to Databricks console, I can see the metastore in North Europe I created.

However, when I select the metastore in North Europe, I get the following error:

If I want to create a new metastore in NorthEU I cannot do it because it says there is already one:

How could I solve the issue ?

Thanks in advance

szymon_dybczak — Fri, 04 Jul 2025 09:49:13 GMT

Maybe there's some hiccup on UI side. Could you try to use REST API or databricks cli?
You can use following endpoint to list all metastores associated with your account:

- Get all metastores associated with an account | Account Metastores API | REST API reference | Databricks on AWS

Check if the metastore causing problem is still there, note its metastore_id and then execute following endpoint:

- Delete a metastore | Account Metastores API | REST API reference | Databricks on AWS

mbanxp — Mon, 07 Jul 2025 14:36:51 GMT

I used CLI to get all metastores associated with the account and I got 2 metastores:

The metastore I want to delete is the first one, and when I tried to delete it by using the following command:

>> databricks metastores delete <metastore_id>

I got the following error:

Error: ~\.databrickscfg does not contain workspace profiles; please create one by running 'databricks configure'

Milica-Panic — Mon, 07 Jul 2025 15:31:34 GMT

Delete the Metastore through API call. Don't do it if you are not ready to loose your UC!! You can:

if you are not able to do this, you can try to delete the metastore assignment first:

sridharplv — Mon, 07 Jul 2025 19:14:31 GMT

I am also facing similar issue @mbanxp . Will keep you posted if i am able to find RCA.

mbanxp — Tue, 08 Jul 2025 16:41:33 GMT

I solved the issue by deleting all the asignments before deleting the metastore.

1. Access to Databricks CLI and authenticate

2. List metastores

>> databricks account metastores list

3. List wotrkspaces and check assignments

>> databricks account workspaces list

>> databricks account metastore-assignments get <workspace_id>

4. Delete assignments one by one

>> databricks account metastore-assignments delete <workspace_id> <metastore_id>

5. Force deletion of metastore because it still had some catalogs, credentials and different artifacts.

>> databricks account metastores delete <metastore_id> --force