topic Re: Can't create a new metastore. Error "This region already contains a metastore" in Data Governance

Can't create a new metastore. Error "This region already contains a metastore"

ashu_sama — Wed, 08 Nov 2023 02:33:18 GMT

I can't create a metastore. Getting an error "This region already contains a metastore. Only a single metastore per region is allowed." But that was my first time creating it.

Afterwards I have checked if it was region specific... but that was also not the case.

Re: Can't create a new metastore. Error "This region already contains a metastore"

ashu_sama — Wed, 08 Nov 2023 17:37:51 GMT

Hi @Retired_mod , I am on a trial subscription and using it for learning purposes. I am the only user(admin). This error was encountered at the time of creation of metastore for the first time. After that I deleted the metastore and all the resources related to check if it was region specific but that too didn't work.

Re: Can't create a new metastore. Error "This region already contains a metastore"

karthik_p — Wed, 08 Nov 2023 18:03:16 GMT

@ashu_sama to benefit all features of UC, you need to be on premium subscription

Re: Can't create a new metastore. Error "This region already contains a metastore"

ashu_sama — Thu, 09 Nov 2023 02:17:58 GMT

@karthik_p , As per my knowledge, the Databricks Workspace needs to be on premium plan which can be created in 'Trial Subscription' of azure as well. I can create a cluster to support Unity Catalog too. Please correct me if I have understood it wrong.

Re: Can't create a new metastore. Error "This region already contains a metastore"

ashu_sama — Thu, 09 Nov 2023 04:19:30 GMT

RESOLVED:-

Open Databricks Workspace-->Admin Setting-->Workspace Settings--> Scroll to Storage --> Click on Purge for 'Permanently purge workspace storage' & 'Permanently purge all revision history'.

FYI: It may work by just purging the workspace storage.