My account Book a demo
Snowflake Data Dictionary Query Toolbox

List sessions / active connections in Snowflake

Article for: SQL Server Azure SQL Database Oracle database Amazon Redshift Teradata Vertica PostgreSQL MySQL MariaDB

To see active sessions ins snowflake we must use Web User Interface.

Requirements

To list active sessions you must be logged as an user with ACCOUNTADMIN role.

Sessions

In the main tab pane, select Account (1) and then click on the Sessions tab (2). Opened window contain information about all connected sessions.

sample results

Transactions

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.

Query

show transactions in account;

Result

sample results