How to Abort / Kill a Snowflake Session or Cancel a Query

With the correct permissions and a session id, or query id, you either abort an existing session, or cancel / kill a running query.

To abort a session, you must 1st obtain the session id:

Show your own session id:

select current_session();

Show all active sessions:

Both from AccountAdmin role you can:

SHOW TRANSACTIONS IN ACCOUNT

select * from snowflake.account_usage.sessions;

Going to have to use AccountAdmin role to use this function.

select SYSTEM$ABORT_SESSION( <session_id> );

Here’s the link in the Snowflake documentation to abort a session:

There is also a system function to cancel all queries for a given session, documented here:

To cancel a given query by query id use this:

select

SYSTEM$CANCEL_QUERY( <query_id> )

Post Views: 5