Hi Shibi,

Please give a try with below code and let me know if the error still persists.

resource "databricks_metastore" "example" {
provider = databricks.azure_account
metastore_id = "your_existing_metastore_id" # Put your metastore ID here
delta_sharing_scope = "INTERNAL_AND_EXTERNAL"
delta_sharing_recipient_token_lifetime_in_seconds = 600000
}

Keep trying! Happy Data engineering.

Regards,

Brahma

Hi , Still i am getting same issue " has reached the limit for metastores in region "

Regards,

Shibin 

Hi Shibhi,

Try adding metastore_id to your workspace.

resource "databricks_metastore_assignment" "example" {
provider = databricks.azure_account
workspace_id = "your_workspace_id" # Replace with your actual workspace ID
metastore_id = "your_existing_metastore_id" # Ensure this matches the metastore you want to use
}

Save the Terraform file with the above code.

Run terraform to update the metastore or assignment.

Hi ,

When it getting created the databrikcs workspace its automatically assigning to the metastore, I was looking to update the metastor delta sharing , And when we user "databricks_metastore" , "Name" parameter is mandatory 

Oh okay, Shibi.

give a try with this approach below.

resource "databricks_metastore" "example" {
provider = databricks.azure_account
metastore_id = "your_existing_metastore_id" # Ensure this is the correct metastore ID
name = "metastore_azure_northeurope" # This should match the existing metastore's name
delta_sharing_scope = "INTERNAL_AND_EXTERNAL"
delta_sharing_recipient_token_lifetime_in_seconds = 600000
}

To avoid creating the metastore again , follow below.

The metastore_id and name match exactly with the existing metastore in your Databricks environment. Double-check that the provider configuration is correctly pointing to your existing Databricks environment.

Give a try and let me know if it works.

Regards,

Brahma

Hi, Thank you for the suggestions, 

But i am still getting same error .