USERS view (Account Usage and Organization Usage): New columns and changes to has_mfa column (Preview)

Attention

This behavior change is in the 2025_04 bundle.

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

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

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

Language: English