Schemas:

ACCOUNT_USAGE

USERS View

This Account Usage view can be used to query a list of all users in the account. The data is retained for 365 days (1 year).

Columns

Column Name

Data Type

Description

NAME

VARCHAR

A unique identifier for the user.

CREATED_ON

TIMESTAMP_LTZ

Date and time (in the UTC time zone) when the user’s account was created.

DELETED_ON

TIMESTAMP_LTZ

Date and time (in the UTC time zone) when the user’s account was deleted.

LOGIN_NAME

VARCHAR

Name that the user enters to log into the system.

DISPLAY_NAME

VARCHAR

Name displayed for the user in the Snowflake web interface.

FIRST_NAME

VARCHAR

First name of the user.

LAST_NAME

VARCHAR

Last name of the user.

EMAIL

VARCHAR

Email address for the user.

MUST_CHANGE_PASSWORD

BOOLEAN

Specifies whether the user is forced to change their password on their next login.

HAS_PASSWORD

BOOLEAN

Specifies whether a password was created for the user.

COMMENT

VARCHAR

Comment for the user.

DISABLED

VARIANT

Specified whether the user account is disabled preventing the user from logging in to the Snowflake and running queries.

SNOWFLAKE_LOCK

VARIANT

Specifies whether a temporary lock has been placed on the user’s account.

DEFAULT_WAREHOUSE

VARCHAR

The virtual warehouse that is active by default for the user’s session upon login.

DEFAULT_NAMESPACE

VARCHAR

The namespace (database only or database and schema) that is active by default for the user’s session upon login.

DEFAULT_ROLE

VARCHAR

The role that is active by default for the user’s session upon login.

EXT_AUTHN_DUO

VARIANT

Specifies whether Duo Security is enabled for the user, which requires the user to use MFA (multi-factor authorization) for login.

EXT_AUTHN_UID

VARCHAR

The authorization ID used for Duo Security.

BYPASS_MFA_UNTIL

TIMESTAMP_LTZ

The number of minutes to temporarily bypass MFA for the user.

LAST_SUCCESS_LOGIN

TIMESTAMP_LTZ

Date and time (in the UTC time zone) when the user last logged in to the Snowflake.

EXPIRES_AT

TIMESTAMP_LTZ

The date and time when the user’s status is set to EXPIRED and the user can no longer log in. This is useful for defining temporary users (e.g. users who should only have access to Snowflake for a limited time period).

LOCKED_UNTIL_TIME

TIMESTAMP_LTZ

Specifies the number of minutes until the temporary lock on the user login is cleared.

HAS_RSA_PUBLIC_KEY

BOOLEAN

Specifies whether RSA public key used for key pair authentication has been set up for the user.

PASSWORD_LAST_SET_TIME

TIMESTAMP_LTZ

The timestamp on which the last non-null password was set for the user. Default to null if no password has been set yet or if Snowflake is unable to determine the timestamp for the user before the inclusion of this column.

Usage Notes

  • Latency for the view may be up to 120 minutes (2 hours).