USERS view (ACCOUNT_has_mfa column¶
Attention
This behavior change is in the 2025_06 bundle.
For the current status of the bundle, refer to Bundle History.
Note
This behavior change was part of the 2025_04 behavior change bundle, but the change has been postponed to the 2025_06 bundle.
When this behavior change bundle is enabled, the ACCOUNT_USAGE USERS view and the ORGANIZATION_USAGE USERS view include the following new columns:
| Column name | Data type | Description |
|---|---|---|
has_pat | BOOLEAN | If TRUE, a programmatic access token (PAT) has been generated for the user. |
has_workload_identity | BOOLEAN | If TRUE, the user is configured to use workload identity federation to authenticate with Snowflake. |
Note
These new columns appear between the default_secondary_role column and the type column.
If you have SELECT statements that use column positions to select specific columns, you need to update those SELECT statements to use the new column positions.
In addition, the has_mfa column now supports the newly introduced MFA methods (TOTP and
passkeys). If the user is enrolled in any MFA method, has_mfa is TRUE.
Ref: 2102