01-31-2023 01:51 AM
I tried to start the Databricks SQL Warehouse cluster today, but received the following error message:
Clusters are failing to launch. Cluster launch will be retired Request to create a cluster failed with an exception: PERMISSION_DENIED: User xxxx is not part of org: xxxx
I believe the error is due to a member that left the team last week. Because he created the SQL Warehouse cluster he is probably a default admin. How do we remove the user as an admin from the SQL Warehouse?
02-01-2023 11:02 PM
Hi, Please refer to https://docs.databricks.com/sql/admin/sql-endpoints.html#configure-sql-warehouse-permissions and https://docs.databricks.com/security/access-control/sql-endpoint-acl.html , please let us know if this helps.
02-23-2023 02:36 PM
Hi @Joakim Torsvik,
Just a friendly follow-up. Did any of the responses help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.
02-23-2023 02:59 PM
Hello @Jose Gonzalez
Sadly no. A colleague told me that there is a bug in the Databricks SQL warehouse which attaches the creator as an immovable owner of the SQL warehouse-cluster.
This is a problem limited to the SQL warehouse-cluster it seems.
To bypass the issue we deleted our SQL warehouse-cluster and created a new one.
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.