A complex query has been running in Snowsight for more than one hour. At the same time, several other queries from other worksheets ran successfully.
What is FASTEST way to cancel the long-running query?
A complex query has been running in Snowsight for more than one hour. At the same time, several other queries from other worksheets ran successfully.
What is FASTEST way to cancel the long-running query?
"From other worksheet". Go to the worksheet with the long running query and clic abort.
https://docs.snowflake.com/en/user-guide/querying-cancel-statements The recommended way to cancel a statement is to use the interface of the application in which the query is running (e.g. the Worksheet in the Snowflake web interface) or the cancellation API provided by the Snowflake ODBC or JDBC driver. However, in some cases, it is necessary to cancel a query using SQL. Snowflake provides the following functions to support using SQL to cancel running/active statements: SYSTEM$CANCEL_ALL_QUERIES SYSTEM$CANCEL_QUERY I say B.