Schema:: ACCOUNT_USAGE

SESSIONS view¶

This Account 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
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 180 minutes (3 hours).
The view displays data starting from July 20-21, 2020.

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).