topic Re: Error in SQL Warehouse: User is not part of org in Data Engineering

Error in SQL Warehouse: User is not part of org

jomt — Tue, 31 Jan 2023 09:51:58 GMT

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?

Re: Error in SQL Warehouse: User is not part of org

jose_gonzalez — Thu, 23 Feb 2023 22:36:56 GMT

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.

Re: Error in SQL Warehouse: User is not part of org

jomt — Thu, 23 Feb 2023 22:59:19 GMT

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.

Re: Error in SQL Warehouse: User is not part of org

Debayan — Thu, 02 Feb 2023 07:02:46 GMT

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.

Re: Error in SQL Warehouse: User is not part of org

akshay4996 — Wed, 14 May 2025 08:19:03 GMT

Hi All,

What you need to do is set a new owner. You can do this by clicking on permissions, then the setup icon, and choosing Assign new owner.
It works for me.

Thanks