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

  2. Status planned to change in January 2025 to Enabled by Default; however, this schedule is subject to change.

  3. Status planned to change in February 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 (Pending)

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

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

Network security: Cannot activate an empty network policy (Pending)

Network security: Cannot attach egress network rule to a network policy (Pending)

Stronger Default Password Policies (Pending)

SQL Changes — General

Additional Notes

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

SQL Changes — Commands & Functions

Additional Notes

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

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

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

Object tagging commands, functions, and views: New column and property (Pending)

SHOW and DESCRIBE commands for listings: New columns in output (Pending)

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

SHOW ICEBERG TABLES command: New column in output (Pending)

SHOW MANAGED ACCOUNTS command: New and modified columns in output (Pending)

SHOW SCHEMAS command: New columns in output (Pending)

SHOW SERVICE CONTAINERS IN SERVICE command: New columns in output (Pending)

SHOW TASKS/DESC TASK commands: New columns in output (Pending)

SHOW USERS command: NULL values replace default values in output (Pending)

SHOW VERSIONS IN MODEL: New columns in output (Pending)

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 (Pending)

LISTING_ACCESS_HISTORY view (DATA_SHARING_USAGE): Deprecate LISTING_OBJECTS_ACCESSED column (Pending)

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

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

TABLES views and SHOW OBJECTS command: New column IS_HYBRID (Pending)

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

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

WAREHOUSE_EVENTS_HISTORY view: New columns in output (Pending)

WAREHOUSE_METERING_HISTORY view (ACCOUNT_USAGE): New column (Pending)

Replication

Additional Notes

Replication: Support for replicating machine learning models (Pending)

Extensibility & Developer Changes

Additional Notes

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

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

Telemetry: Event table attribute name and value changes (Pending)

Web Interface

Additional Notes

Deprecation of worksheet results sharing and secondary roles in dashboards (Pending)

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 (Pending)

Added to the 2024_08 BCR Bundle

07-Oct-24

Stronger Default Password Policies (Pending)

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 (Pending)

Added to the 2024_08 BCR Bundle

07-Oct-24

WAREHOUSE_METERING_HISTORY view (ACCOUNT_USAGE): New column (Pending)

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 (Pending)

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 (Pending)

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 (Pending)

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

Language: English