Removing storage account location from metastore fails

Bayees
Databricks Partner

‎02-11-2025 07:04 AM

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

Bayees_0-1739286165573.png

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

0 Kudos

Takuya-Omi
Valued Contributor III

‎02-15-2025 11:11 AM

@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...

--------------------------
Takuya Omi (尾美拓哉)
0 Kudos

Bayees
Databricks Partner

‎02-23-2025 11:50 PM

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.

0 Kudos