2024_02 Bundle

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 — GeneralAdditional 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 & FunctionsAdditional 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 FunctionsAdditional 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 LoadingAdditional 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 LakeAdditional Notes
GET_DDL function: Return source Apache Iceberg™ data types
Apache Iceberg™ tables: Updates to metadata retention period
ReplicationAdditional 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 & DeveloperAdditional 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 WarehousesAdditional Notes
Query Acceleration Service: Expanded support for INSERT statements

Behavior Change Bundle change log

AnnouncementUpdateDate
Python UDFs: Changes to return value types for semi-structured dataMoved to 2024_03 Bundle26-Mar-2023
Replication: Skip external and Apache Iceberg™ tables during refresh operationAdded to the 2024_02 BCR Bundle20-Feb-24
Query Acceleration Service: Expanded support for INSERT statementsAdded to the 2024_02 BCR Bundle20-Feb-24
2024_02 BCR Bundle notesPending release (preview)19-Feb-24
Replication: Stages, pipes, storage integrations, and load historyMoved to the 2024_02 BCR Bundle15-Feb-24
ALTER USER command: Case sensitivity when specifying a default role (Pending)Removed from SQL Changes — Commands & Functions08-Feb-24
2024_02 BCR Bundle notesInitial publication (preview)06-Feb-24