Serverless SQL Datawarehouse cluster failing to launch

[HZ]

Hope someone may able to help, got a serverless SQL datawarehouse in SQL workspace, it was created by another member in the team and it had been working all good over past month.

The person who created this serverless SQL datawarehouse left the team and his account is removed.

Then when I try to use the serveless SQL datawarehouse or start the SQL datawarehouse, get an error of cluster failing to launch.

I do have permission to create cluster under the Data Science and Engineering workspace and have the rights of Can Manage under SQL workspace.

Is there anything else i shall do or check to solve this problem?

[Debayan]

Hi @Helen Zhang​ , Could you please mention the error getting surfaced when you are trying to launch the cluster?

[HZ]

I think the user in the error message is the one we removed, who created the sql datawarehouse. Does it mean if the person who created the sql datawarehouse left the organisation, other member wont be able to start the cluster in that sql datawarehouse and need to re create another one? Thanks

[karthik_p]

@Helen Zhang​ on the left side (with 3 dots) of Start tab of you SQL warehouse, can you see if you can add your username

[HZ]

Yes, i have already added myself as Can Manage for the SQL warehouse and get the above error message

[Anonymous]

Hi @Helen Zhang​ 

Hope all is well!

Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. 

We'd love to hear from you.

Thanks!