topic ERROR-cannot create Metastore-has reached the limit for Metastores in region-need Assistance in Data Governance

ERROR-cannot create Metastore-has reached the limit for Metastores in region-need Assistance

jv_v — Fri, 10 May 2024 18:53:09 GMT

Message: Hi Databricks Community,
I encountered an error while attempting to create a Metastore in Databricks. The error message is as follows:
Error: cannot create metastore: This account with id ******************** has reached the limit for Metastores in region westus2
When am trying to create Metastore using terraform, I found above error message even there is no Metastore exists in the region. please find below terraform code for reference.

resource "databricks_metastore" "this" {

name = var.metastore_name

storage_root = format ("abfss://%s@%s.dfs.core.windows.net/",

azurerm_storage_container.unity_catalog.name,

azurerm_storage_account.unity_catalog.name)

force_destroy = true

owner = var.owner

}

output "output_metastore" {

value = databricks_metastore.this.metastore_id

Could someone please provide guidance on how to address this issue? Specifically, I'm interested in understanding how to manage or increase the metastore limit for my account in the westus2 region.

Re: ERROR-cannot create Metastore-has reached the limit for Metastores in region-need Assistance

Hkesharwani — Fri, 17 May 2024 14:38:21 GMT

Hi,
As per the documentation, we can create only one meta store per region per account .
https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/create-metastore
Although databricks can make an exception and allow you to create multiple metastores. You may raise a support ticket for the same.

Re: ERROR-cannot create Metastore-has reached the limit for Metastores in region-need Assistance

raphaelblg — Wed, 22 May 2024 22:59:24 GMT

Hello @jv_v,

Please contact Databricks support through the Databricks Help Center.

Re: ERROR-cannot create Metastore-has reached the limit for Metastores in region-need Assistance

dkushari — Wed, 22 May 2024 23:29:35 GMT

Hi, @jv_v; when was this workspace created? Can you please check this article and see that you already do not have a default UC metastore created?

Re: ERROR-cannot create Metastore-has reached the limit for Metastores in region-need Assistance

shibi — Wed, 14 Aug 2024 13:42:34 GMT

Even i am getting same error when i try to modify metastore with terraform script , i am using below script for same.( I have already the metastore in same region but i am not able to update the setting )

resource "databricks_metastore" "example" {

provider= databricks.azure_account

name = "metastore_azure_northeurope"

owner = var.databricksGroupName

delta_sharing_scope = "INTERNAL_AND_EXTERNAL"

delta_sharing_recipient_token_lifetime_in_seconds = 600000

}