QUERY_HISTORY View (Account Usage): New Columns Added

Attention

This behavior change is in the 2023_01 bundle.

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

The following columns have been added to the Account Usage QUERY_HISTORY view in the shared SNOWFLAKE database.

Column Name

Data Type

Description

TRANSACTION_ID

NUMBER

Specifies either the ID of the transaction that wraps the statement or 0 if the statement is not executed within a transaction. The new column can be used to join data in the QUERY_HISTORY and LOCK_WAIT_HISTORY views to examine multi-statement transactions.

CHILD_QUERIES_WAIT_TIME

NUMBER

Specifies the number of milliseconds to complete a child job for a query. Note that a child job only applies to certain Snowflake queries. Snowflake pauses the main query, the child job completes, and then the main query resumes.

Ref: 921