Hi everyone,I'm running into an issue with my Starter Warehouse on Databricks and would appreciate any help or pointers.Problem: My SQL Warehouse has been stuck in a Starting state with the following warning:Cluster Start-up Delayed. Please wait whil...
It's not possible to use the ALTER TABLE tblname OWNER TO serviceprinc1 command in Azure Databricks, as this isn't supported. I was trying to set a catalog table's ownership, but it resulted in an error. How can I achieve this using a script
Hi Ashwin,Thank you.Just to update you on my end : my 14-day trial was expiring so I upgraded to a Pay-As-You-Go Premium subscription. However, after upgrading I tried starting the SQL Warehouse again and got the same startup error.Following your adv...
Hi Ashwin, thanks for the detailed response!To answer your questions:- Cloud: Azure- Workspace type: Trial workspace (14-day trial, created via the Azure Portal around 2 weeks ago)- How long stuck: More than 10 minutes each time- Retry behaviour: Yes...
it turns out that The ALTER TABLE statement in Databricks SQL does not support changing the owner of a table directly.It seems we need to use REST API to do the same