LOGIN_HISTORY view and table function (Account Usage / Information Schema): New columns in output (Pending)

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 LOGIN_HISTORY view and the output of the INFORMATION_SCHEMA LOGIN_HISTORY table function include the following new columns:

Column name

Data type

Description

first_authentication_factor_id

VARCHAR

ID of the credential used to authenticate the user (the first factor, if using multi-factor authentication).

second_authentication_factor_id

VARCHAR

ID of the credential used for the second factor, if using multi-factor authentication. If the user did not use multi-factor authentication, this value is NULL.

Ref: 1966