QUERY_HISTORY views and function: New columns in output (Preview)

Attention

This behavior change is in the 2025_06 bundle.

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

When this behavior change bundle is enabled, the ACCOUNT_USAGE QUERY_HISTORY view, the ORGANIZATION_USAGE QUERY_HISTORY view, and the output of the QUERY_HISTORY table function include the following new columns:

Column name

Data type

Description

authn_event_id

NUMBER

ID for the event for the authentication of the user for this query. This ID corresponds to the value in the event_id column in the LOGIN_HISTORY view.

Note

This column appears between the session_id and user_name columns.

If you have queries that rely on the order of the columns in this view, you need to update those queries to account for the new column.

bind_values

VARIANT

Values of bind variables used in this query.

The column contains an OBJECT value. The value contains a key-value pair, where the key is the name of the bind variable and the value is another OBJECT value with the following key-value pairs:

  • type: Snowflake data type of the value.

  • value: Value of the bind variable.

For example:

{
  "model_name": {
    "type": "TEXT",
    "value": "mistral-large2"
  }
}
Copy

This column appears after the last column in the view (user_schema_id).

If you don’t want bind values to be accessible to users, set the ALLOW_BIND_VALUES_ACCESS account-level parameter to FALSE:

ALTER ACCOUNT SET ALLOW_BIND_VALUES_ACCESS = FALSE;
Copy

Ref: 1980, 2050

Language: English