topic Getting an error while editing databrics metastore "databricks_metastore" using terraform (Azure) in Get Started Discussions

Getting an error while editing databrics metastore "databricks_metastore" using terraform (Azure)

shibi — Wed, 14 Aug 2024 13:56:55 GMT

Hi ,

I am getting an error (Metastore has reached the limit for metastores in region ) while updating metatsore using terraform , below the script i am using for updating metastore . There is already a metastore available i dont want to create the new one, i just want to update some property using terraform .

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

}

Re: Getting an error while editing databrics metastore "databricks_metastore" using terraf

Brahmareddy — Thu, 15 Aug 2024 04:25:07 GMT

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

Re: Getting an error while editing databrics metastore "databricks_metastore" using terraf

shibi — Thu, 15 Aug 2024 14:26:08 GMT

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

Regards,

Shibin

Re: Getting an error while editing databrics metastore "databricks_metastore" using terraf

Brahmareddy — Thu, 15 Aug 2024 15:18:57 GMT

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.

Re: Getting an error while editing databrics metastore "databricks_metastore" using terraf

shibi — Thu, 15 Aug 2024 15:25:36 GMT

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

Re: Getting an error while editing databrics metastore "databricks_metastore" using terraf

Brahmareddy — Thu, 15 Aug 2024 16:01:57 GMT

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

Re: Getting an error while editing databrics metastore "databricks_metastore" using terraf

shibi — Thu, 15 Aug 2024 17:52:42 GMT

Hi, Thank you for the suggestions,

But i am still getting same error .