Snowflake provides function to terminate specific session on a server.
Find session ID
First we will identify the session we want to end.
We can make it by listing all sessions on the server in the Web User Interface:
If our transcation has lock on resources we can get session id from query below:
show locks in account;
Now we will use session ID to abort the session (6137508847650 in our example):
select SYSTEM$ABORT_SESSION( 6137508847650 );