databricks / terraform-databricks-examples

Examples of using Terraform to deploy Databricks resources
https://registry.terraform.io/modules/databricks/examples/databricks/latest
Other
214 stars 133 forks source link

User does not have CREATE CATALOG on Metastore 'primary' on adb-unity-catalog-basic-demo #121

Open rkkalluri opened 9 months ago

rkkalluri commented 9 months ago

databricks_catalog.dev: Creating... ╷ │ Error: cannot create catalog: User does not have CREATE CATALOG on Metastore 'primary'. │ │ with databricks_catalog.dev, │ on main.tf line 140, in resource "databricks_catalog" "dev": │ 140: resource "databricks_catalog" "dev" { │

I had to issue couple of grants to the user running Terraform apply. Even though this user is already federated to the workspace and is a metastore admin. He is also in the account_unity_admin group from AD federated down to the workspace.

GRANT CREATE EXTERNAL LOCATION ON METASTORE TO user; GRANT CREATE CATALOG ON METASTORE TO user;