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 — General

Additional 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 & Functions

Additional 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 Functions

Additional 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 Changes

Additional Notes

Snowpipe: Multiple auto-ingest notification integrations with the same URL not allowed for Azure and GCP

Data Pipelines

Additional 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 Governance

Additional Notes

SHOW FUNCTIONS commands: New is_data_metric column

TABLE_STORAGE_METRICS view (Account Usage): New column

Developer / Extensibility Changes

Additional 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 API

Additional Notes

Snowflake Native App Framework: Enforce REFERENCE usage on databases containing tags and policies

Web Interface

Additional Notes

Snowsight: Default interface for all users in Standard Edition accounts

Bundle Notes Change Log¶

Announcement

Update

Date

Postponed

CURRENT_DATABASE and CURRENT_SCHEMA functions: Ensure deterministic outputs with policies, views, and UDFs (Pending)

19-Jan-24