Unbundled Behavior Changes¶

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

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.

Information Schema: TABLE_PRIVILEGES view.

TABLE_PRIVILEGES View: Update GRANTOR column value in the consumer account (Postponed)

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

This change is not available for testing.

Cloning: Table history.

Cloning: Table history not preserved on clone (Postponed)

This behavior change was originally in the 2023_07 bundle and intended to become enabled by default in the 2023_08 bundle. 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

March 26, 2024

SQL Changes — Organization Usage Views

Organization Usage: Updated billing views

March 04-05, 2024

Data Pipelines: Dynamic Tables

Dynamic tables: Changes to ACCOUNT_USAGE.TABLES and INFORMATION_SCHEMA.TABLES

Nov 30, 2023

Snowflake Native App Framework

Snowflake Native App Framework: Need to recreate or update some APPLICATION objects

As part of bundle 2023_08

Web Interface Changes

Snowsight: Default interface for all users in Standard Edition accounts

Nov 14, 2023

Snowflake Native App Framework

Snowflake Native App Framework: Providers must accept terms of service to set the DISTRIBUTION property to EXTERNAL

Nov 14, 2023

Snowflake Native App Framework

Snowflake Native App Framework Changes to the version output for the SHOW APPLICATIONS and DESC APPLICATION commands

Nov 7, 2023

Snowflake Native App Framework

Snowflake Native App Framework Cannot use “UNVERSIONED” as the prefix of a version label

October 23, 2023

SQL Changes — Usage Views & Information Schema Views / Table Functions

WAREHOUSE_EVENTS_HISTORY view: Change to the CLUSTER_NUMBER column output

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