topic Re: how to cancel or kill a long running sql query from databricks python notebook.I have a long run in Data Engineering

how to cancel or kill a long running sql query from databricks python notebook.I have a long running

slakshmanan — Tue, 08 Oct 2024 21:39:31 GMT

how to cancel or kill a long running sql query from databricks python notebook.I have a long running sql query in sql warehouse

Re: how to cancel or kill a long running sql query from databricks python notebook.I have a long run

szymon_dybczak — Wed, 09 Oct 2024 02:19:16 GMT

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

Re: how to cancel or kill a long running sql query from databricks python notebook.I have a long run

szymon_dybczak — Wed, 09 Oct 2024 03:01:15 GMT

Interrupt button looks like below:

Re: how to cancel or kill a long running sql query from databricks python notebook.I have a long run

slakshmanan — Wed, 09 Oct 2024 14:36:35 GMT

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

Re: how to cancel or kill a long running sql query from databricks python notebook.I have a long run

szymon_dybczak — Wed, 09 Oct 2024 15:00:54 GMT

I don't think that exist such an endpoint yet. At least, I couldn't find it in documentation.