Error in SQL Warehouse: User is not part of org
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Labels:
-
SQL
-
Sql Warehouse
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.