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.

3 REPLIES 3

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
Self-taught Data Engineer | Seeking Remote Full-time Opportunities

raphaelblg
Contributor III
Contributor III

Hello @jv_v

Please contact Databricks support through the Databricks Help Center.

Best regards,

Raphael Balogo
Sr. Technical Solutions Engineer
Databricks

dkushari
New Contributor III
New Contributor III

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

 

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!