Snowflake provides function to terminate specific session on a server.

Find session ID

First we will identify the session we want to end.

User Interface

We can make it by listing all sessions on the server in the Web User Interface:

Show Locks

If our transcation has lock on resources we can get session id from query below:

show locks in account;

Kill session

Now we will use session ID to abort the session (6137508847650 in our example):

select SYSTEM$ABORT_SESSION( 6137508847650 );

Result