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

[jv_v]

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.

[Hkesharwani]

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.

[raphaelblg]

Hello @jv_v, 

Please contact Databricks support through the Databricks Help Center.

[dkushari]

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? 

[shibi]

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

}