2024_01 捆绑包

捆绑包历史记录

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

变更列表

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 the 捆绑包说明变更日志.

SQL Changes — GeneralAdditional Notes
ASOF JOIN syntax: Restricted use of keywords
Sequences and columns: New sequences and columns use NOORDER by default
SQL Changes — Commands & FunctionsAdditional Notes
DESC SECRET command: Add INTEGRATION_NAME column
GRANT PRIVILEGES … TO ROLE command: Creating instances and privilege format
IS_DATABASE_ROLE_IN_SESSION: Name resolution with policy and UDF evaluation
SHOW commands: Update OWNER column for objects owned by Snowflake
SHOW FUNCTIONS and SHOW PROCEDURES commands: Changes to output
SQL Changes — Usage Views & Information Schema Views / Table FunctionsAdditional Notes
Account Usage views: Add support for versioned schemas in Snowflake Native Apps
Account Usage views: Column updates to support the Snowflake Native App Framework
GRANTS_TO_ROLES View (Account Usage): Match SHOW GRANTS TO ROLE command
LOAD_HISTORY and COPY_HISTORY Information Schema views: Showing only post-truncate load history
NOTIFICATION_HISTORY table function: New column in output
Data LoadingAdditional Notes
Snowpipe and Tasks: Updates to Azure Event Grid notifications
Data PipelinesAdditional Notes
Dynamic tables: disallow using SQL UDFs and UDTFs in new dynamic tables
Data GovernanceAdditional Notes
Versioned schemas: Disallow policy assignments across schemas
Versioned schemas: Disallow tag propagation
ReplicationAdditional Notes
Replication Groups: New column in output of SHOW command and Information Schema View
Extensibility & DeveloperAdditional Notes
Snowflake Native Apps: Introduce maximum number of scanned patches

捆绑包说明变更日志

AnnouncementUpdateDate
Moved

Replication: Stages, pipes, storage integrations, and load history

Moved to the 2024_02 BCR Bundle.

15-Feb-24
Rewrite

SHOW commands: Update OWNER column for objects owned by Snowflake

更清楚地指明变化的命令和值。

12-Feb-24
Update

GRANT PRIVILEGES … TO ROLE command: Creating instances and privilege format

将 SNOWFLAKE.CORE.COMPARE 从变化的类列表中移除。

09-Feb-24
Update07-Feb-24