This behavior change is in the 2023_01 bundle. In the 7.2 release, the bundle is disabled by default.
For the most up-to-date details about the version and date in which it will be enabled, as well as other release-related details, see the Behavior Change Log.
The following columns have been added to the Account Usage QUERY_HISTORY view in the shared SNOWFLAKE database.
|
Column Name
|
Description
|
|
CHILD_QUERIES_WAIT_TIME
|
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.
|
|
TRANSACTION_ID
|
ID of transaction that wraps the statement (see transaction ID) 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.
|
Ref: 921
