August 22-23, 2023 – 7.29 Release Notes (with behavior changes)¶

Behavior Changes Bundles¶

This release contains the following behavior change bundles:

The status for each bundle will change in the next behavior change release, planned for September; however, this schedule is subject to change.

For more information about bundle statuses and how they may impact your accounts, see About Behavior Changes.

Non-bundled Pending Behavior Changes¶

The following changes are pending, but are not part of a bundle, and therefore cannot be enabled for testing:

• Stronger UTF-8 validation for external files

SQL Updates¶

GET_QUERY_OPERATOR_STATS Function — General Availability¶

With this release, we are pleased to announce the general availability of the GET_QUERY_OPERATOR_STATS system function, which provides programmatic access to the query profile. For more information, see GET_QUERY_OPERATOR_STATS.

Using the Query Hash to Identify Patterns and Trends in Queries¶

Snowflake now provides the hash of the query text in the views and table functions that provide historical data on queries. You can use the hash of the query text to identify, group, and analyze similar queries in the query history.

The following Account Usage views and Information Schema table functions now include a hash of the canonicalized SQL text of the query:

• The following Account Usage views:

  • QUERY_HISTORY view
  • QUERY_ACCELERATION_ELIGIBLE view
  • TASK_HISTORY view

• The following Information Schema table functions:

  • QUERY_HISTORY , QUERY_HISTORY_BY_*
  • TASK_HISTORY

Note that these columns are present only when the 2023_06 bundle is enabled.

For more information, see Using the Query Hash to Identify Patterns and Trends in Queries.

New SQL Functions¶

The following function(s) are now available with this release: