Unbundled Behavior Changes¶

Unbundled bevahior changes are not associated or released with a behavior change bundle.

To help you manage your operations and minimize disruption to your Snowflake service, we document behavior changes that may impact your usage, including:

Upcoming pending changes that will not be part of a behavior change bundle and cannot be enabled in advance.
Recently implemented changes that were previously pending/disabled, were not part of a behavior change bundle, and cannot be disabled.

If you have questions about any of these behavior changes, please feel free to contact Snowflake Support.

Upcoming Pending Changes¶

The following table lists unbundled behavior changes that are pending. Pending unbundled behavior changes have not been released yet.

Important

All information in this table, including planned versions and dates, is subject to change; the information is provided only as a guideline for any updates you need to make to accommodate the changes.

If a link is not provided to the individual pending behavior change, the release in which the bundle was introduced has not started or is is still in progress.

Planned Release	Functional Area	Pending Behavior Change	Additional Notes
	Snowflake CLI, Connectors, Drivers, and SQL API Changes	SnowSQL- Change to the value of the sql_split property (Pending)
Implementation complete for Azure East US 2 and Canada Central regions. Remaining regions scheduled to be implemented in 2022.	Infrastructure Changes	Microsoft Azure subnet expansion (Pending for selected accounts)	This change only impacts accounts hosted on Azure that are using the functionality documented in the provided article: If you have not been contacted by Snowflake Support, your accounts are not impacted. If you have been contacted, to prevent any disruption to your service, the required tasks should be completed before the scheduled implementation date. This change is not available for testing.
	Data Loading / Unloading Changes.	Data loading, data unloading, and file staging DML commands: Single-character pattern matches (Postponed)	This change was originally planned for February, 2021; however, it has been postponed and a new release date has not been determined. This change is not available for testing.

Planned Release

Functional Area

Pending Behavior Change

Additional Notes

Snowflake CLI, Connectors, Drivers, and SQL API Changes

SnowSQL- Change to the value of the sql_split property (Pending)

Implementation complete for Azure East US 2 and Canada Central regions.

Remaining regions scheduled to be implemented in 2022.

Infrastructure Changes

Microsoft Azure subnet expansion (Pending for selected accounts)

This change only impacts accounts hosted on Azure that are using the functionality documented in the provided article:

If you have not been contacted by Snowflake Support, your accounts are not impacted.
If you have been contacted, to prevent any disruption to your service, the required tasks should be completed before the scheduled implementation date.

This change is not available for testing.

Data Loading / Unloading Changes.

Data loading, data unloading, and file staging DML commands: Single-character pattern matches (Postponed)

This change was originally planned for February, 2021; however, it has been postponed and a new release date has not been determined.

This change is not available for testing.

Recently Implemented Changes¶

This table lists behavior changes that were implemented independently of a behavior change bundle. These changes include certain types of changes to Snowflake clients (connectors, drivers, etc.), platforms, and libraries. Such changes cannot be disabled.

Release Date	Functional Area	Implemented Behavior Change	Additional Notes
Sep 28, 2023.	Data Loading and Unloading	Stronger UTF-8 validation for external files
Sep 19, 2023.	SQL Changes — Commands & Functions	SHOW APPLICATIONS command: Changes to the LABEL column output	This change is enabled by default and cannot be disabled.
Aug 23, 2023	SQL Changes — Security	CREATE USER command: NETWORK_POLICY parameter must specify a valid network policy
Sep 27, 2022	Snowflake CLI, Connectors, Drivers, and SQL API Changes	Snowflake Connector for Python: Empty results of fetch_arrow and fetch_pandas are typed
Aug 24, 2022	Snowflake CLI, Connectors, Drivers, and SQL API Changes	Snowflake .NET driver update - August 2022	Snowflake .NET driver 2.0.16: Replaces .NET Standard 2.0 with .NET 6.0
Nov, 2021	Ecosystem Changes	Snowflake SQL API: Changes to the process of submitting SQL statements
Jul, 2021	Ecosystem Changes	Snowflake Connector for Python 2.5.0: Changes to the `write_pandas()` function
Jun, 2021	Platform Changes	Microsoft Azure subnet expansion	This change was implemented, but deactivated for impacted accounts to allow the accounts to make updates as needed.
Mar, 2021	SQL Changes —– General	Search Optimization Service: Changes to billing reporting
Feb, 2021	SQL Changes —– General	Stored procedures and UDFs: Upgrade to the JavaScript engine	This change was implemented as part of the 5.3.1 scheduled patch on February 4, 2021.