2024_08 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.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 changed in the 9.7 release (March 17-27, 2025) 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 ChangesAdditional 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 — GeneralAdditional Notes
SQL data types: Changes to maximum length, output, and error messages
SQL Changes — Commands & FunctionsAdditional 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 FunctionsAdditional 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
ReplicationAdditional Notes
Replication: Support for replicating machine learning models
Extensibility & Developer ChangesAdditional 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 InterfaceAdditional Notes
Deprecation of worksheet results sharing and secondary roles in dashboards

Behavior Change Bundle change log

AnnouncementUpdateDate
Released as previewBundle 2024_08 announcements released as preview.04-Oct-2024
Default value for the SYNC_PASSWORD parameter on SCIM security integrations has changedAdded to the 2024_08 BCR Bundle07-Oct-24
Stronger Default Password PoliciesAdded to the 2024_08 BCR Bundle07-Oct-24
Use primary role for authorizing view and materialized view creation (Canceled)Added to the 2024_08 BCR Bundle07-Oct-24
Multi-factor authentication enrollment enforced by default for new Snowflake accountsAdded to the 2024_08 BCR Bundle07-Oct-24
WAREHOUSE_METERING_HISTORY view (ACCOUNT_USAGE): New columnColumn 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 messagesUpdated to now include information about changes to UDF metadata in the event table08-Oct-24
Deprecation of worksheet results sharing and secondary roles in dashboardsUpdated to now include Knowledge Base articles08-Oct-24
Updated as completeBundle 2024_08 announcements released.09-Oct-2024
Multi-factor authentication enrollment enforced by default for new Snowflake accountsUpdated 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 Bundle12-Nov-24
GRANT OWNERSHIP ON ROLE command: Restrict transfer of role ownership to itself (Canceled)Removed from the 2024_08 BCR Bundle17-Dec-24
CREATE … CLONE command: Cloning databases and schemas that contain hybrid tablesUpdated the description; cloning is now supported for hybrid tables.25-Feb-25