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 |
---|---|---|
|
VARCHAR |
ID of the credential used to authenticate the user (the first factor, if using multi-factor authentication). |
|
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