2024_02 Bundle

Note

This bundle contains a replication behavior change that might result in objects being dropped in target accounts. For more information, see Replication: Stages, pipes, storage integrations, and load 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. 在 8.7 版本(2 月 19 日至 21 日)中引入,状态为 默认禁用;账户管理员可以启用测试。
  2. 在 8.12 版本(3 月 26 日至 27 日)中,状态更改为 默认启用;账户管理员可以禁用以选择退出。
  3. 在 8.17 版本(4 月 30 日至 5 月 7 日)中,状态更改为 普遍启用;账户管理员无法再启用或禁用该捆绑包。

变更列表

Important

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

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 行为变更捆绑包变更日志.

SQL — GeneralAdditional Notes
CREATE and ALTER DATABASE commands: Database names starting with “datacloud$” no longer allowed
Snowflake Native App Framework: Update error message when an app is disabled
SQL Changes — Commands & FunctionsAdditional Notes
DESCRIBE ICEBERG TABLE command: New column
SHOW/DESC SERVICE commands and Information Schema and Account Usage SERVICES views: New IS_JOB column
SQL functions: Passing in columns that have the upper, lower, or trim collation specifier
SHOW APPLICATIONS command: New UPGRADE_STATUS column
SQL Changes — Usage Views & Information Schema Views / Table FunctionsAdditional Notes
Information Schema: New columns in output for QUERY_HISTORY, QUERY_HISTORY_BY_* functions
QUERY_HISTORY view (Account Usage): Changes to columns and new columns
Account Usage views: Additional rows added to support versioned schemas
Data LoadingAdditional Notes
Transforming data during a load: Disallow using MATCH_BY_COLUMN_NAME with a SELECT statement
Data Pipelines
Dynamic tables: Return value changes and new columns added to DYNAMIC_TABLE_GRAPH_HISTORY, DYNAMIC_TABLE_REFRESH_HISTORY, and SHOW DYNAMIC TABLES
Data LakeAdditional Notes
GET_DDL function: Return source Apache Iceberg™ data types
Apache Iceberg™ tables: Updates to metadata retention period
ReplicationAdditional Notes
Replication: Stages, pipes, storage integrations, and load history
Replication: Skip external and Apache Iceberg™ tables during refresh operation
Replication: Changes to refresh operations that fail with dangling reference errors
Extensibility & DeveloperAdditional Notes
Python Snowpark Stored Procedures and UDFs: Tracing improvements in Event table
Snowpark Container Services: Error if image is not found when creating service or job
Virtual WarehousesAdditional Notes
Query Acceleration Service: Expanded support for INSERT statements

行为变更捆绑包变更日志

公告更新日期
Python UDFs: Changes to return value types for semi-structured dataMoved to 2024_03 Bundle2023 年 3 月 26 日
Replication: Skip external and Apache Iceberg™ tables during refresh operation已添加 至 2024_02 BCR 捆绑包2024 年 2 月 20 日
Query Acceleration Service: Expanded support for INSERT statements已添加 至 2024_02 BCR 捆绑包2024 年 2 月 20 日
2024_02 BCR 捆绑包说明待发布(预览版)2024 年 2 月 19 日
Replication: Stages, pipes, storage integrations, and load history已移动 至 2024_02 BCR 捆绑包2024 年 2 月 15 日
ALTER USER 命令:指定默认角色时区分大小写(待定)Removed from SQL Changes — Commands & Functions2024 年 2 月 8 日
2024_02 BCR 捆绑包说明初次发布(预览版)2024 年 2 月 6 日