snowflake-cloud-data-platformsnowsql
How do you stop a running query in SnowSQL
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?
Solution
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
- How to create a dynamic pivot table in Snowflake?
- Azure Data Factory V2 Copy Activity is not cleaning/deleting staged files/containers after copying data to the destination (Like: Snowflake)
- Count / Sum JSON variant attribute Flatten
- Difference between LATERAL FLATTEN(...) and TABLE(FLATTEN(...)) in Snowflake
- How to merge nested json in snowflake?
- Alternatives to sliding window frames with RANGE on snowflake
- Snowflake SQL Range between interval
- Snowflake SQL stored procedure not working
- How to add a hyphen after an nth character in Snowflake
- How to query a Snowpark dataframe, with SQL, from Snowflake?
- Snowflake improve search join IP over Network
- Create OBJECT with column values as Key in Snowflake
- Information_schema INVALID IDENTIFIER from snowflake when trying to access query history through a python script
- How can I efficiently transform a two-column range into an expanded table?
- Stored Procedure: add parameter for month or hour
- parquet files generated by snowflake are not readable by other tools
- Terraform Snowflake: create a database without public schema
- Dynamically lateral flatten in Snowflake
- snowflake Time travel data is not available
- Exactly what dialect of SQL does snowflake support
- Snowflake - get notified of any task errors when copy is set to "on_error = continue"
- Snowflake - Lateral flatten
- Snowflake SQLAlchemy - Create table with Timestamp?
- How to parse nested json in snowflake using lateral flatten
- Create nested queries with SQLAlchemy
- How to include count column with filter to calculate percentage out of a total where total has different filters in Snowflake?
- how to add Interval time in snowflake using a parameter
- How to find count of groups a particular IDs belong to in Snowflake?
- How to replace strings in a column if exist in a list with dbt jinja?
- Snowflake - want to revert back to previous version of table before I replaced it