2024_01 Bundle

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.2 release (January 15-17) as Disabled by Default; account admins can enable for testing.
  2. Status changed in the 8.7 release (February 19-21) to Enabled by Default; account admins can disable for opt-out.
  3. Status changed in the 8.12 release (March 26-27) 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 the Bundle Notes Change Log.

SQL Changes — GeneralAdditional Notes
ASOF JOIN syntax: Restricted use of keywords
Sequences and columns: New sequences and columns use NOORDER by default
SQL Changes — Commands & FunctionsAdditional Notes
DESC SECRET command: Add INTEGRATION_NAME column
GRANT PRIVILEGES … TO ROLE command: Creating instances and privilege format
IS_DATABASE_ROLE_IN_SESSION: Name resolution with policy and UDF evaluation
SHOW commands: Update OWNER column for objects owned by Snowflake
SHOW FUNCTIONS and SHOW PROCEDURES commands: Changes to output
SQL Changes — Usage Views & Information Schema Views / Table FunctionsAdditional Notes
Account Usage views: Add support for versioned schemas in Snowflake Native Apps
Account Usage views: Column updates to support the Snowflake Native App Framework
GRANTS_TO_ROLES View (Account Usage): Match SHOW GRANTS TO ROLE command
LOAD_HISTORY and COPY_HISTORY Information Schema views: Showing only post-truncate load history
NOTIFICATION_HISTORY table function: New column in output
Data LoadingAdditional Notes
Snowpipe and Tasks: Updates to Azure Event Grid notifications
Data PipelinesAdditional Notes
Dynamic tables: disallow using SQL UDFs and UDTFs in new dynamic tables
Data GovernanceAdditional Notes
Versioned schemas: Disallow policy assignments across schemas
Versioned schemas: Disallow tag propagation
ReplicationAdditional Notes
Replication Groups: New column in output of SHOW command and Information Schema View
Extensibility & DeveloperAdditional Notes
Snowflake Native Apps: Introduce maximum number of scanned patches

Bundle Notes Change Log

AnnouncementUpdateDate
Moved

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

Moved to the 2024_02 BCR Bundle.

15-Feb-24
Rewrite

SHOW commands: Update OWNER column for objects owned by Snowflake

Specify the commands and values that are changing more clearly.

12-Feb-24
Update

GRANT PRIVILEGES … TO ROLE command: Creating instances and privilege format

Remove SNOWFLAKE.CORE.COMPARE from the list of classes that are changing.

09-Feb-24
Update07-Feb-24