Information

Summary

Last Modified Date	January 19, 2023

Article Body

This article provides a list of the behavior changes and other related changes in the release:

Deprecated Features (none in this release)
Overview of Behavior Change Bundles in this Release
2022_06 Bundle: Generally Enabled
2022_07 Bundle: Enabled by Default; Available for Opt-out
2022_08 Bundle: Disabled by Default; Available for Testing
Other Upcoming Changes (none in this release)
Other Implemented Changes (none in this release)

Back to: Announcements

Important: This change list has been compiled using reasonable efforts. We are not always able to determine the full customer impact of a behavior change beforehand. The change list may not include all changes in a release, for example, last minute or emergency changes. In addition, behavior changes that are determined to have minimal to no user impact may not be pre-announced.

If you have any questions, please contact Snowflake Support.

Deprecated Features

This section lists features that are deprecated as of this update. The list may include deprecated operating system or language versions for Snowflake clients.

No deprecated features to announce for this release. For other deprecated features, see the Behavior Change Log.

Overview of Bundles in This Release

The following behavior change bundles are included in this release:

Bundle	Status in Release	Notes
2022_06	Generally enabled Previous status: Enabled by default	Once your accounts have been moved to this release, the changes in this bundle will be active regardless of whether the bundle was disabled previously. You can still request a temporary extension for individual changes in the bundle.
2022_07	Enabled by default Previous status: Disabled by default	Once your accounts have been moved to the release, the changes in this bundle will be active unless you choose to opt-out by explicitly disabling the bundle for the desired accounts.
2022_08	Disabled by default Previous status: N/A (introduced in this release)	This bundle is scheduled to be enabled by default in October 2022; however, this schedule is subject to change.

For more details about each bundle and the actions you can perform, see the individual sections in this article.

2022_06 Bundle: Generally Enabled

This bundle, which was previously enabled by default (and could be disabled for individual accounts), is now generally enabled across all accounts.

Consequently, the behavior changes in the bundle are active and you can no longer enable or disable the bundle in your accounts; however, you can contact Snowflake Support and request a temporary extension for individual changes in the bundle.

Functional Area	Changes in Bundle (Generally Enabled)
SQL — General	Replication Groups: Objects Types Limited to Databases and Shares for Accounts that are not Business Critical Edition Fail-safe Storage: Bug Fix for Corner Cases that Result in Underbilling
SQL — Commands & Functions	CREATE DATABASE & CREATE SCHEMA Commands: OR REPLACE Clause Results in Dangling References for Policies INFER_SCHEMA Function: New ORDER_ID Column in Output
SQL — Usage Views & Information Schema Views/Table Functions	FUNCTIONS View (Account Usage Schema): New Columns in View

2022_07 Bundle: Enabled by Default; Available for Opt-out

This bundle, which was previously disabled by default, is now enabled by default.

The behavior changes in the bundle are active in your accounts unless you opt out of the changes by explicitly disabling the bundle in your desired accounts.

Functional Area	Changes in Bundle (Enabled by Default)
SQL — Commands & Functions	Databases & Schemas: Dropping or Replacing Not Allowed if Results in Dangling References for Policies and Tags CREATE MATERIALIZED VIEW Command: Time Travel Clauses No Longer Allowed
SQL — Usage Views & Information Schema Views/Table Functions	GRANT_TO_ROLES View (Account Usage): Changes to the View
Data Lakes	CREATE EXTERNAL TABLE Command: User-specified Partitions and Automatically Refreshed Metadata GET_DDL Function: Returns TABLE_FORMAT Parameter for External Tables on Delta Lake
Extensibility	Snowpark for Python: Returns Errors Earlier When Adding Invalid Packages Snowpark for Scala and Java: Change to Types of Members in DeleteResult, MergeResult, and UpdateResult

2022_08 Bundle: Disabled by Default; Available for Testing

This bundle is being introduced for the first time in this release. It is disabled by default, but available for testing. To test the behavior changes in the bundle, you can enable the bundle in your desired accounts.

Note: The bundle cannot be enabled in an account until the account has been moved to the release.

Functional Area	Changes in Bundle (Disabled by Default)
Security	SAML2 Security Integrations: Enforcing the Validity Dates of X.509 Certificates (Pending)
SQL — Commands & Functions	Database & Schemas: Dropping or Replacing Not Allowed if Results in Dangling References for Password Policies and Session Policies (Pending) SHOW FUNCTIONS Command: New Column in Output (Pending) SHOW VIEWS Command: New Column in Output (Pending) GET_DDL: Support Added for Tags & Policies (Pending)
SQL — Usage Views & Information Schema Views/Table Functions	Data Sharing Usage Views: Changes to Column in Views (Pending) ACCESS_HISTORY View (Account Usage): New Columns in the View (Pending) FUNCTIONS View (Information Schema): New Column in View (Pending) TABLE_CONSTRAINTS View (Account Usage): New Column in View (Pending) USAGE_IN_CURRENCY_DAILY View (Organization Usage): New Column in View (Pending) USERS View (Account Usage): New Column in View (Pending)
Data Sharing	Consumers: SHOW Commands Return Error If Account Has Been Revoked from Share (Pending)
Replication	Network Policies: Dangling References for Policies with Replication & Failover/Failback (Pending) Replication Groups: Read-only Account Parameters in Target Accounts (Pending) Replication Groups: Limit Account Objects to Membership in a Single Group (Pending) SHOW REPLICATION GROUPS Command: Changes to Output (Pending)

Other Upcoming Changes

This section lists upcoming changes that are not included in a behavior change bundle.

None to announce in this release.

Other Implemented Changes

This section lists recently implemented changes that were not included in a behavior change bundle.