Removing storage account location from metastore fails

[Bayees]

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.

[Takuya-Omi]

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

[Bayees]

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.