Deply databricks workspace on azure with terraform - failed state: legacy access

[Hil]

I'm trying to deploy a workspace on azure via terraform and i'm getting the following error:

"INVALID_PARAMETER_VALUE: Given value cannot be set for workspace~<id>~default_namespace_ws~ because: cannot set default namespace to hive_metastore since legacy access is disabled"

My thought was to set the default namespace to that of the UC. However, this only possible within the workspace itself, which in my case cannot be provisioned. Have anyone dealt with this issue?

To give a bit of context:

- I've setup a UC for the region that is set to be automatically assigned to new workspaces
- When manually provisioning a workspace everything work as expected

Any insight will be helpful, thanks!

[belforte]

This error happens because the legacy hive_metastore is disabled, and Terraform is trying to use it as the default namespace.The fix is to set the default namespace to Unity Catalog (UC) in your Terraform config, or leave it unset so UC is applied automatically.

[nayan_wylde]

@Hil 

You need to tell Terraform not to set the default namespace to hive_metastore, but instead to your UC catalog (or just leave it unset so Databricks auto-assigns UC).

In Terraform (Databricks provider), the relevant field is workspace.default_namespace:

resource "databricks_mws_workspaces" "this" {
  # … your existing config …
  workspace_name = "my-ws"

  # Force default namespace to your UC catalog
  workspace {
    default_namespace = "my_catalog"   # <-- replace with your actual UC catalog
  }
}