How do you stop a running query in SnowSQL

Question

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?

Hardener

I'm having the same issue on OSX. I run a query that prints data to the screen and I cant kill it with ctrl+d, ctrl+c etc, might be worth raising a support case to get it fixed? – Millais

Answer 1

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

SnowSQL verion : v1.2.5
Operating System : Windows

Bulbul

Must be a Linux / osx bug – Millais

thanks! it definitely sounds like a bug. I'm using 1.2.5 in Linux and can't stop it. I'll try some other computer and see if it happens often. I'll accept this answer as this is the answer for what I asked – Hardener

Answer 2

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.

Bushed