- Schema:
SESSIONS view¶
Important
This view is only available in the organization account. For more information, see Premium views in the organization account.
This Organization Usage view provides information on the session, including information on the authentication method to Snowflake and the Snowflake login event. Snowflake returns one row for each session created over the last year.
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
ORGANIZATION_NAME |
VARCHAR |
Name of the organization. |
ACCOUNT_LOCATOR |
VARCHAR |
System-defined identifier for an account. |
ACCOUNT_NAME |
VARCHAR |
User-defined identifier for an account. |
SESSION_ID |
Number |
The unique identifier for the current session. |
CREATED_ON |
TIMESTAMP_LTZ |
Date and time (in the UTC time zone) when the session was created. |
USER_NAME |
String |
The user name of the user. |
AUTHENTICATION_METHOD |
String |
The authentication method used to access Snowflake. |
LOGIN_EVENT_ID |
Number |
The unique identifier for the login event. |
CLIENT_APPLICATION_VERSION |
String |
The version number (e.g. 3.8.7) of the Snowflake-provided client application used to create the remote session to Snowflake. |
CLIENT_APPLICATION_ID |
String |
The identifier for the Snowflake-provided client application used to create the remote session to Snowflake (e.g. JDBC 3.8.7) |
CLIENT_ENVIRONMENT |
String |
The environment variables (e.g. operating system, OCSP mode) of the client used to create a remote session to Snowflake. |
CLIENT_BUILD_ID |
String |
The build number (e.g. 41897) of the third-party client application used to create a remote session to Snowflake, if available. For example, a third-party Java application that uses the JDBC driver to connect to Snowflake. |
CLIENT_VERSION |
String |
The version number (e.g. 47154) of the third-party client application that uses a Snowflake-provided client to create a remote session to Snowflake, if available. . |
CLOSED_REASON |
String |
The reason why a Snowflake session closes. One of the following: UNKNOWN, DROP_USER, LOGOUT, FORCED_LOGOUT, ABANDONED, OAUTH_CRITICAL_CHANGE_INTEGRATION, DROP_ACCOUNT, OAUTH_CONSENT_REVOKED, TASK_COMPLETED, SFC_FORCED_LOGOUT. |
Usage notes¶
Latency for the view may be up to 24 hours.
The SESSIONS view does not currently track SQL API transient sessions.
This view does not record the activity of internal users the system defines to perform various operations (e.g. maintain Snowsight worksheets).