2023_08 捆绑包(正式启用)

捆绑包历史记录

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. 在 7.41 版本(2023 年 11 月 11–14 日)中引入,状态为 默认禁用;账户管理员可以启用测试。
  2. 在 8.2 版本(2024 年 1 月 15 日至 17 日)中,状态更改为 默认启用;账户管理员可以禁用以选择退出。
  3. 在 8.7 版本(2024 年 2 月 19 日至 21 日)中,状态更改为 普遍启用;账户管理员无法再启用或禁用该捆绑包。

变更列表

Important

此变更列表是经过合理努力编制而成的。我们并不总是能够事先确定行为变更对客户的全部影响。变更列表可能不包括版本中的所有变更,例如最后一刻或紧急变更。此外,确定对用户影响最小甚至没有影响的行为变更可能不会预先宣布。

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

捆绑包说明变更日志

公告更新日期
已推迟BCR-13252024 年 1 月 19 日
已更新BCR-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 UDFs2024 年 7 月 23 日