2024_01 Bundle (Generally Enabled)¶

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 — General

Additional Notes

ASOF JOIN syntax: Restricted use of keywords

Sequences and columns: New sequences and columns use NOORDER by default

SQL Changes — Commands & Functions

Additional 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 Functions

Additional 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 Loading

Additional Notes

Snowpipe and Tasks: Updates to Azure Event Grid notifications

Data Pipelines

Additional Notes

Dynamic tables: disallow using SQL UDFs and UDTFs in new dynamic tables

Data Governance

Additional Notes

Versioned schemas: Disallow policy assignments across schemas

Versioned schemas: Disallow tag propagation

Replication

Additional Notes

Replication Groups: New column in output of SHOW command and Information Schema View

Extensibility & Developer

Additional Notes

Snowflake Native Apps: Introduce maximum number of scanned patches

Bundle Notes Change Log¶

Announcement

Update

Date

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

Update

07-Feb-24