July 10-12, 2023 — 7.23 Release Notes (with behavior changes)¶

The following new features and updates (enhancements, fixes, etc.) have been introduced in this release. If you have any questions, please contact Snowflake Support.

Important

Each release may include updates that require the web interface to be refreshed.

As a general practice, to ensure these updates do not impact your usage, we recommend refreshing the web interface after each Snowflake release has been deployed.

Behavior Changes Bundles¶

This release contains the following behavior change bundles:

Bundle Name	Status in this Release	Previous Status
2023_05	Disabled by default; admins can enable for testing	N/A (introduced in this release)
2023_04	Enabled by default; admins can disable for opt-out	Disabled by default
2023_03	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 August; however, this schedule is subject to change.

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

New Features¶

Schema Detection and Evolution for Kafka Connector With Snowpipe Streaming — Preview¶

With this release, we are pleased to announce that the Kafka connector with Snowpipe Streaming now supports schema detection and evolution. The structure of tables in Snowflake can be defined and evolved automatically to support the structure of new Snowpipe streaming data loaded by the Kafka connector.

To use this feature, you need to enable the behavior changes in bundle 2023_05.

For more information, see Schema detection and evolution for Kafka connector with Snowpipe Streaming.

SQL Updates¶

SYSTEM$CLUSTERING_INFORMATION Returns Error Messages¶

With this release, we are pleased to announce that the SYSTEM$CLUSTERING_INFORMATION function now returns recent errors associated with Automatic Clustering. These errors, returned as JSON objects in an array, explain why Automatic Clustering could not recluster data. By default, the 10 most recent errors are returned by the function. To allow users to return more or fewer messages, the SYSTEM$CLUSTERING_INFORMATION function now accepts a number as its second argument. This number specifies how many errors should be returned.

For more information, see SYSTEM$CLUSTERING_INFORMATION.

Web Interface Updates¶

Snowsight Set as Default Web Interface¶

With this release, behavior changes in bundle 2023_04 are enabled by default. As a result, all customers of Snowflake On Demand have Snowsight set as the default web interface for all users in the account and new users of Snowflake have Snowsight set as their default web interface.

For more information, see About the Snowsight upgrade.