SESSIONS View (Account Usage): New Column in View¶

Attention

This behavior change is in the 2023_03 bundle.

For the current status of the bundle, refer to Bundle History.

The behavior of the SESSIONS Account Usage view in the shared SNOWFLAKE database behaves as follows:

Previously:

The view does not include the CLOSED_REASON column.

Currently:

The view includes the CLOSED_REASON column as the last column in the view. The column contains one of the following values to indicate why the Snowflake session closes:

UNKNOWN
DROP_USER
LOGOUT
FORCED_LOGOUT
ABANDONED
OAUTH_CRITICAL_CHANGE_INTEGRATION
DROP_ACCOUNT
OAUTH_CONSENT_REVOKED
TASK_COMPLETED
SFC_FORCED_LOGOUT

Regarding logouts, note the following:

FORCED_LOGOUT refers to an account administrator in your Snowflake account forcing a user to logout.

SFC_FORCED_LOGOUT refers to a Snowflake administrator (e.g. Support engineer) forcing a user to logout.

Ref: 991