LOGIN_HISTORY view and functions: New LOGIN_DETAILS column (Preview)¶
Attention
This behavior change is in the 2025_07 bundle.
For the current status of the bundle, refer to Bundle History.
When this behavior change bundle is enabled, the following view and functions include a new column named login_details
in their output.
ACCOUNT_USAGE.LOGIN_HISTORY view
INFORMATION_SCHEMA.LOGIN_HISTORY function output
INFORMATION_SCHEMA.LOGIN_HISTORY_BY_USER function output
This column contains information about login details, such as malicious IP protection status and risk classification. The column is added as the last column of the view or command output.
Column name |
Data type |
Description |
---|---|---|
login_details |
VARCHAR |
Provides information related to login details. |
Examples:
Example 1:
{"malicious_ip_protection_info":"{\"categories\":[\"MALICIOUS_BEHAVIOR\"],\"result\":\"OPTED_OUT\",\"riskClassification\":\"LOW\"}"}
Example 2:
{"malicious_ip_protection_info":"{\"categories\":[\"ANONYMOUS_VPN\",\"TOR_EXITS\"],\"result\":\"BLOCKED\",\"riskClassification\":\"HIGH\"}"}
Ref: 2052