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.

Introduced in the 8.38 release (October 7-9, 2024) as Disabled by Default; however, account admins can enable for testing.
Status changed in the 9.2 release (January 22-February 13, 2025) to Enabled by Default; account admins can disable for opt-out.
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