Knowledge Drop

How to kill long running queries through the API


Userlevel 1

Last tested: Apr 8, 2020
 

To kill a long running query through the API, you can first get a list of all running queries through the `all_running_queries` endpoint and write a script where if the running time is greater than threshold, then `kill_query`.

Example code here: Kill Long Running Queries

If you want to kill any long running queries that are not part of a scheduled report, the all_running_queries endpoint has a source field and you can exclude the source in the example script.

 

This content is subject to limited support.                

 

 


3 replies

Hey @mandy.chan 

Hope you are well.

The lonk to Kill Long Running Queries  does not work any more,

Will you please fix?

thanks

Userlevel 2

Phone pay customer care number 7978471163/24/7978471163

Userlevel 2

Phone pay customer care number 7978471163/24/7978471163Phone pay customer care number 7978471163/24/7978471163Phone pay customer care number 7978471163/24/7978471163

Reply