Error in SQL Warehouse: User is not part of org

[jomt]

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?

[Debayan]

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.

[jose_gonzalez]

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.

[jomt]

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.

[akshay4996]

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