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

Behavior Changes Bundles¶

This release contains the following behavior change bundles:

Bundle Name	Status in this Release	Previous Status
2023_06	Disabled by default; admins can enable for testing	N/A (introduced in this release)
2023_05	Enabled by default; admins can disable for opt-out	Disabled by default
2023_04	Generally enabled; admins can no longer enable/disable	Enabled by default

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:
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:

Function Category	New Function	Description
Semi-Structured Data Functions (Array/Object)	ARRAY_MAX	Given an input ARRAY, returns the element with the highest value that is not a SQL NULL.
Semi-Structured Data Functions (Array/Object)	ARRAY_MIN	Given an input ARRAY, returns the element with the lowest value that is not a SQL NULL.
Semi-Structured Data Functions (Array/Object)	ARRAY_SORT	Returns an ARRAY that contains the elements of the input ARRAY sorted in ascending or descending order.