Error: cannot create metastore data access

niklas — Tue, 14 Nov 2023 13:09:08 GMT

I'm in the progress of enabling Databricks Unity Catalog and encountered a problem with the databricks_metastore_data_access Terraform resource:

resource "databricks_metastore_data_access" "this" {
  provider = databricks.account-level

  metastore_id  = databricks_metastore.this.id
  name          = "mi-access-databricks-metastore"
  owner         = "admin-group"
  force_destroy = true
  is_default    = true

  azure_managed_identity {
    access_connector_id = azurerm_databricks_access_connector.this.id
  }
}

The Terraform apply run will always fail with following error: Error: cannot create metastore data access:
Unfortunately I get no more error details than the message from above.

The funny thing is that all other Unity Catalog related resource were created successfully and looking at the Account Console I can see that the metastore was assigned to my Databricks workspace.

So my question: Do you know for what the metastore data access resource is used for and do I even need it? If yes, how can I fix this issue?

Re: Error: cannot create metastore data access

niklas — Sat, 18 Nov 2023 09:26:31 GMT

Found a solution. Please see my answer on Stack Overflow:
https://stackoverflow.com/questions/77440091/databricks-unity-catalog-error-cannot-create-metastore-data-access/77506306#77506306

topic Error: cannot create metastore data access in Administration & Architecture

Error: cannot create metastore data access

Re: Error: cannot create metastore data access