How do you stop a running query in SnowSQL

user_3620775 0
Viewed 2001

Is it possible to stop a running query in the SnowSQL command line tool? Let's say I made a mistake and I tried to run a heavy query. Control-C, Esc, Q... nothing seems to stop it. The only way seems to be to send a kill command.

I also tried to stop a query when I'm paging but it seems like I'm forced to go through all pages before being able to stop.

Is there any way to stop queries in any of these two situations?

snowsql snowflake-cloud-data-platform
2 Answers

ctrl+c is working fine for me, I executed a simple query

select * from <HUGE TABLE>;

While the results are getting displayed on the command window I fired the ctrl+c

enter image description here

SnowSQL verion : v1.2.5
Operating System : Windows
user_134840600

This cancels the query.

SELECT SYSTEM$CANCEL_QUERY( 'query_id' )

The query ID can be obtained from the Account->History. Many companies do not allow access to account for developers, but can add permissions to allow access to query history.

user_96376310
Related