cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
Join discussions on data governance practices, compliance, and security within the Databricks Community. Exchange strategies and insights to ensure data integrity and regulatory compliance.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

jv_v
New Contributor III

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.

4 REPLIES 4

Hkesharwani
Contributor II

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.

Harshit Kesharwani
Data engineer at Rsystema

raphaelblg
Honored Contributor II

Hello @jv_v

Please contact Databricks support through the Databricks Help Center.

Best regards,

Raphael Balogo
Sr. Technical Solutions Engineer
Databricks

dkushari
Contributor

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? 

dkushari_0-1716420556960.png

 

shibi
New Contributor III

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
}

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