terraform-databricks-examples
terraform-databricks-examples copied to clipboard
User does not have CREATE CATALOG on Metastore 'primary' on adb-unity-catalog-basic-demo
trafficstars
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;