2024_04 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.17 release (April 30 - May 7) as Disabled by Default; account admins can enable for testing.

  2. Status changed in the 8.22 release (June 11-15) to Enabled by Default; account admins can disable for opt-out.

  3. Status changed in the 8.27 release (July 22-25) 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.

Security Changes

Additional Notes

Snowflake Native App Framework: Roles with the ATTACH LISTING privilege can run the DESCRIBE APPLICATION PACKAGE command

SQL Changes — Commands & Functions

Additional Notes

DESC FUNCTION command: New column IS_AGGREGATE in output

DESCRIBE SESSION POLICY: Add allowed_secondary_roles column

SHOW ENDPOINTS command: New column and changes to output

SHOW SHARES command: New column (SECURE_OBJECTS_ONLY)

SHOW TABLES command, TABLES view, and GET_DDL command: Changes related to the READ ONLY property for tables

SHOW VERSIONS IN MODEL command: New column aliases

SHOW/DESC COMPUTE POOL command: New columns

SHOW/DESC SERVICE commands and Information Schema view: New STATUS column

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

Additional Notes

Account Usage views: Add support for versioned schemas in Snowflake Native Apps

NOTIFICATION_HISTORY table function: Changes to output

LISTING_CONSUMPTION_DAILY view: New columns

STAGES View (ACCOUNT_USAGE): New Column STORAGE_INTEGRATION

Virtual Warehouse

Additional Notes

WAREHOUSE_EVENTS_HISTORY view (ACCOUNT_USAGE): New columns and changes to events

Data Pipelines

Additional Notes

Dynamic tables: Updates to dynamic table default refresh mode

Data Governance

Additional Notes

Masking policy: Comply with the scale and precision of a column

Replication

Additional Notes

Replication support for CREATE <class_name> privilege

Extensibility & Developer

Additional Notes

Event tracing: Trace IDs propagated from parent to child through procedure calls

Snowpark Container Services: Changes to access control for services and endpoints

Behavior Change Bundle change log

Announcement

Update

Date

Masking policy: Comply with the scale and precision of a column

Remove references to length of a column

28-Jul-24

Logging and tracing: Default event table included (Postponed)

Behavior change postponed and announced in Logging and tracing: Default event table included

10-May-24

2024_04 BCR Bundle notes

Pending release (preview)

29-Apr-24

Language: English