2024_02 Bundle (Generally Enabled)

Note

This bundle contains a replication behavior change that might result in objects being dropped in target accounts. For more information, see Replication: Stages, pipes, storage integrations, and load history.

Bundle History

Attention

To determine the current status of bundles in your account, see SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES.

For more information, see Behavior change management.

  1. Introduced in the 8.7 release (February 19-21) as Disabled by Default; account admins can enable for testing.

  2. Status changed in the 8.12 release (March 26-27) to Enabled by Default; account admins can disable for opt-out.

  3. Status changed in the 8.17 release (April 30 - May 7) to Generally Enabled; account admins can no longer enable or disable this bundle.

List of Changes

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 about the changes in this bundle, please contact Snowflake Support.

For differences between the in-advance and final versions of these notes, see Behavior Change Bundle change log.

SQL — General

Additional Notes

CREATE and ALTER DATABASE commands: Database names starting with “datacloud$” no longer allowed

Snowflake Native App Framework: Update error message when an app is disabled

SQL Changes — Commands & Functions

Additional Notes

DESCRIBE ICEBERG TABLE command: New column

SHOW/DESC SERVICE commands and Information Schema and Account Usage SERVICES views: New IS_JOB column

SQL functions: Passing in columns that have the upper, lower, or trim collation specifier

SHOW APPLICATIONS command: New UPGRADE_STATUS column

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

Additional Notes

Information Schema: New columns in output for QUERY_HISTORY, QUERY_HISTORY_BY_* functions

QUERY_HISTORY view (Account Usage): Changes to columns and new columns

Account Usage views: Additional rows added to support versioned schemas

Data Loading

Additional Notes

Transforming data during a load: Disallow using MATCH_BY_COLUMN_NAME with a SELECT statement

Data Pipelines

Dynamic tables: Return value changes and new columns added to DYNAMIC_TABLE_GRAPH_HISTORY, DYNAMIC_TABLE_REFRESH_HISTORY, and SHOW DYNAMIC TABLES

Data Lake

Additional Notes

GET_DDL function: Return source Apache Iceberg™ data types

Apache Iceberg™ tables: Updates to metadata retention period

Replication

Additional Notes

Replication: Stages, pipes, storage integrations, and load history

Replication: Skip external and Apache Iceberg™ tables during refresh operation

Replication: Changes to refresh operations that fail with dangling reference errors

Extensibility & Developer

Additional Notes

Python Snowpark Stored Procedures and UDFs: Tracing improvements in Event table

Snowpark Container Services: Error if image is not found when creating service or job

Virtual Warehouses

Additional Notes

Query Acceleration Service: Expanded support for INSERT statements

Behavior Change Bundle change log

Announcement

Update

Date

Python UDFs: Changes to return value types for semi-structured data

Moved to 2024_03 Bundle (Generally Enabled)

26-Mar-2023

Replication: Skip external and Apache Iceberg™ tables during refresh operation

Added to the 2024_02 BCR Bundle

20-Feb-24

Query Acceleration Service: Expanded support for INSERT statements

Added to the 2024_02 BCR Bundle

20-Feb-24

2024_02 BCR Bundle notes

Pending release (preview)

19-Feb-24

Replication: Stages, pipes, storage integrations, and load history

Moved to the 2024_02 BCR Bundle

15-Feb-24

ALTER USER command: Case sensitivity when specifying a default role (Pending)

Removed from SQL Changes — Commands & Functions

08-Feb-24

2024_02 BCR Bundle notes

Initial publication (preview)

06-Feb-24