2023_08 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 7.41 release (November 11-14, 2023) with status Disabled by Default; account admins can enable for testing.
  2. Status changed in the 8.2 release (January 15-17, 2024) to Enabled by Default; account admins can disable for opt-out.
  3. Status changed in the 8.7 release (February 19-21, 2024) 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.

SQL Changes — GeneralAdditional Notes
ACCESS_HISTORY View: New parent_query_id and root_query_id columns
DIV0 and DIV0NULL: Change to results exceeding the output scale
Native Apps: Queries that use a reference removed from an app’s manifest file fail
SHOW commands for objects owned by an application: New column owner_role_type
SHOW ORGANIZATION ACCOUNTS command / ACCOUNTS view (Organization Usage): New Column
SQL Changes — Commands & FunctionsAdditional Notes
ALTER TABLE: Incompatible Default Values No Longer Allowed in New Columns
Bind variables: No longer ignored as parameters for some built-in table functions
DESCRIBE TABLE: New column
FUNCTIONS view (Account Usage): New columns
New function: MAP_KEYS may conflict with similarly named UDFs
Replication: Add support for secret object
SHOW GRANTS command: Updates for managed access schema
SHOW RELEASE DIRECTIVES command: new columns
SHOW TABLES command: New is_hybrid column
SHOW TASKS and DESCRIBE TASK commands: New columns
SYSTEM$REFERENCE function: Creating a Reference with Mismatched Object Types Fails
SQL Changes — Usage Views & Information Schema Views / Table FunctionsAdditional Notes
DESC TABLE command, SHOW COLUMNS command, and COLUMNS views: Add new SchemaEvolutionRecord column
FUNCTIONS and PROCEDURES views (INFORMATION_SCHEMA): Corrections to columns When name contains special characters
QUERY_HISTORY view and table functions: New MULTI_STATEMENT value in the query_type column for multi-statement queries
SHOW TABLES command / TABLES view: New is_iceberg column
SYSTEM$ALLOWLIST function: Fail query when socket connection hangs
Data Loading / Unloading ChangesAdditional Notes
Snowpipe: Multiple auto-ingest notification integrations with the same URL not allowed for Azure and GCP
Data PipelinesAdditional Notes
Dynamic tables: Added support for MONITOR privileges
Dynamic tables: OPERATE privilege on upstream dynamic tables required for initial refresh
Tasks: Automatically suspend failed task runs
Tasks: New BACKFILL_INFO column in views
Data GovernanceAdditional Notes
SHOW FUNCTIONS commands: New is_data_metric column
TABLE_STORAGE_METRICS view (Account Usage): New column
Developer / Extensibility ChangesAdditional Notes
Logging and tracing: Logging of unhandled exceptions in handler code on by default
Snowflake Native App Framework: Block creating event tables and temporary stages within an application package
Snowflake CLI, Connectors, Drivers, and SQL APIAdditional Notes
Snowflake Native App Framework: Enforce REFERENCE usage on databases containing tags and policies
Web InterfaceAdditional Notes
Snowsight: Default interface for all users in Standard Edition accounts

Bundle Notes Change Log

AnnouncementUpdateDate
PostponedBCR-132519-Jan-24
UpdatedBCR-1325 is now included in the 2024_06 bundle and listed as CURRENT_DATABASE and CURRENT_SCHEMA functions: Ensure deterministic outputs with policies, views, and UDFs23-Jul-24