topic Re: Removing storage account location from metastore fails in Administration & Architecture

Removing storage account location from metastore fails

Bayees — Tue, 11 Feb 2025 15:04:27 GMT

I am trying to remove the storage account location for our UC metastore. I am getting the error:

I have tried assigning my user and service principal permission to create external location.

Re: Removing storage account location from metastore fails

Takuya-Omi — Sat, 15 Feb 2025 19:11:19 GMT

@Bayees

I think this thread might be helpful for you.

https://community.databricks.com/t5/data-governance/removing-adls-gen-2-path-metastore-root-in-unity-catalog/td-p/63317

Re: Removing storage account location from metastore fails

Bayees — Mon, 24 Feb 2025 07:50:20 GMT

I accomplished it by creating a storage account credential and external location manually. Then I was able to able the remove the metastore path.

What then happen was that the path for __databricks_internal catalog was set to the storage account that was previously specified for metastore. I came to the conclusion that the path cannot and should not be changed for that catalog, since it is used for system tables and DLT functionality.