โ10-08-2024 02:39 PM
how to cancel or kill a long running sql query from databricks python notebook.I have a long running sql query in sql warehouse
โ10-08-2024 07:19 PM
Hi @slakshmanan ,
To stop or interrupt a running notebook, select the interrupt button in the notebook toolbar. You can also select Run > Interrupt execution, or use the keyboard shortcut I I.
https://learn.microsoft.com/en-us/azure/databricks/notebooks/run-notebook
And if you're going to use SQL warehouse then to terminate a long-running query started by you or another user:
View query history.
Click the name of a query.
Next to Status, click Cancel.
https://docs.databricks.com/en/sql/user/queries/query-history.html#terminate-an-executing-query
โ10-08-2024 08:01 PM
Interrupt button looks like below:
โ10-09-2024 07:36 AM
i want to stop it from rest api call or from an python code runnining in databricks to kill long running sql query from warehouse
โ10-09-2024 08:00 AM
I don't think that exist such an endpoint yet. At least, I couldn't find it in documentation.
Passionate about hosting events and connecting people? Help us grow a vibrant local communityโsign up today to get started!
Sign Up Now