To see active sessions ins snowflake we must use Web User Interface.
To list active sessions you must be logged as an user with ACCOUNTADMIN role.
In the main tab pane, select Account (1) and then click on the Sessions tab (2). Opened window contain information about all connected sessions.
Snowflake enables us to fast check currently running transactions of all users in the account. To do it you must be logged as an user with ACCOUNTADMIN role.
show transactions in account;