2024_08 Bundle (Enabled by Default)

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.38 release (October 7-9, 2024) as Disabled by Default; however, account admins can enable for testing.

  2. Status changed in the 9.2 release (January 22-February 13, 2025) to Enabled by Default; account admins can disable for opt-out.

  3. Status planned to change in March 2025 to Generally Enabled; however, this schedule is subject to change.

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

Default value for the SYNC_PASSWORD parameter on SCIM security integrations has changed

Default value of DEFAULT_SECONDARY_ROLES object property on users changed to (‘ALL’)

Multi-factor authentication enrollment enforced by default for new Snowflake accounts

Network security: Cannot activate an empty network policy

Network security: Cannot attach egress network rule to a network policy

Stronger Default Password Policies

SQL Changes — General

Additional Notes

SQL data types: Changes to maximum length, output, and error messages

SQL Changes — Commands & Functions

Additional Notes

CREATE … CLONE command: Cloning databases and schemas that contain hybrid tables

CREATE DYNAMIC ICEBERG TABLE command: Write data types to table files

Object tagging commands, functions, and views: New column and property

SHOW and DESCRIBE commands for listings: New columns in output

SHOW DYNAMIC TABLES command and DYNAMIC_TABLES function: New changes to output

SHOW ICEBERG TABLES command: New column in output

SHOW MANAGED ACCOUNTS command: New and modified columns in output

SHOW SCHEMAS command: New columns in output

SHOW SERVICE CONTAINERS IN SERVICE command: New columns in output

SHOW TASKS/DESC TASK commands: New columns in output

SHOW USERS command: NULL values replace default values in output

SHOW VERSIONS IN MODEL: New columns in output

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

Additional Notes

DATABASES and SCHEMATA views, and SHOW DATABASES and SHOW SCHEMAS commands: New column in output

LISTING_ACCESS_HISTORY view (DATA_SHARING_USAGE): Deprecate LISTING_OBJECTS_ACCESSED column

METERING_HISTORY view (ACCOUNT_USAGE): Database-level output for COPY_FILES

SHOW/DESC SERVICE commands and SERVICES view (ACCOUNT_USAGE and INFORMATION SCHEMA): New column MIN_READY_INSTANCES

TABLES views and SHOW OBJECTS command: New column IS_HYBRID

TASK_HISTORY view (ACCOUNT_USAGE): task usage history restricted to 1 year

USERS and QUERY_HISTORY views (ACCOUNT_USAGE) and QUERY_HISTORY function: New columns

WAREHOUSE_EVENTS_HISTORY view: New columns in output

WAREHOUSE_METERING_HISTORY view (ACCOUNT_USAGE): New column

Replication

Additional Notes

Replication: Support for replicating machine learning models

Extensibility & Developer Changes

Additional Notes

Streamlit in Snowflake: Default Python version for Streamlit in Snowflake apps changes from 3.8 to 3.11

Snowflake Native App Framework: Apps with containers share events with provider when consumer event table not set

Telemetry: Event table attribute name and value changes

Web Interface

Additional Notes

Deprecation of worksheet results sharing and secondary roles in dashboards

Behavior Change Bundle change log

Announcement

Update

Date

Released as preview

Bundle 2024_08 announcements released as preview.

04-Oct-2024

Default value for the SYNC_PASSWORD parameter on SCIM security integrations has changed

Added to the 2024_08 BCR Bundle

07-Oct-24

Stronger Default Password Policies

Added to the 2024_08 BCR Bundle

07-Oct-24

Use primary role for authorizing view and materialized view creation (Canceled)

Added to the 2024_08 BCR Bundle

07-Oct-24

Multi-factor authentication enrollment enforced by default for new Snowflake accounts

Added to the 2024_08 BCR Bundle

07-Oct-24

WAREHOUSE_METERING_HISTORY view (ACCOUNT_USAGE): New column

Column name correction. CREDITS_USED_COMPUTE_QUERIES replaced by CREDITS_ATTRIBUTED_COMPUTE_QUERIES.

07-Oct-24

SQL data types: Changes to maximum length, output, and error messages

Updated to now include information about changes to UDF metadata in the event table

08-Oct-24

Deprecation of worksheet results sharing and secondary roles in dashboards

Updated to now include Knowledge Base articles

08-Oct-24

Updated as complete

Bundle 2024_08 announcements released.

09-Oct-2024

Multi-factor authentication enrollment enforced by default for new Snowflake accounts

Updated the title and clarified the description.

14-Oct-2024

Use primary role for authorizing view and materialized view creation (Canceled)

Removed from the 2024_08 BCR Bundle

12-Nov-24

GRANT OWNERSHIP ON ROLE command: Restrict transfer of role ownership to itself (Canceled)

Removed from the 2024_08 BCR Bundle

17-Dec-24