USERS view (Account Usage and Organization Usage): New columns and changes to has_mfa column (Postponed)¶
Note
This behavior change was part of the 2025_04 behavior change bundle, but the change has been postponed. The change will be introduced in a future bundle. The change is not available for testing.
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 |
|---|---|---|
|
BOOLEAN |
If TRUE, a programmatic access token (PAT) has been generated for the user. |
|
BOOLEAN |
Reserved for future use. |
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: 1981