cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Administration & Architecture
Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Removing storage account location from metastore fails

Bayees
New Contributor II

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.

2 REPLIES 2

Takuya-Omi
Valued Contributor II

@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 (ๅฐพ็พŽๆ‹“ๅ“‰)

Bayees
New Contributor II

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.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group