Snowflake发布10.27版本更新：动态表支持CREATE OR ALTER
Snowflake于2026年8月2日至6日发布10.27版本更新，其中CREATE OR ALTER DYNAMIC TABLE命令正式全面可用（GA）。该命令结合了CREATE DYNAMIC TABLE与ALTER DYNAMIC TABLE的功能，若动态表不存在则创建，存在则按新定义修改，匹配时无操作。此更新简化了数据管道中的表管理流程。
推荐理由：Snowflake动态表是数据湖仓和实时分析的关键能力，CREATE OR ALTER语法将简化管道运维，数据从业者需关注其GA后的行为变化。
湖仓Snowflake
原文
Attention
This release has completed. For differences between the in-advance and final versions of these release notes, see Release notes change log.
Data pipeline updates¶
CREATE OR ALTER DYNAMIC TABLE (General availability)¶
CREATE OR ALTER DYNAMIC TABLE is now generally available. This command combines the functionality of CREATE DYNAMIC TABLE and ALTER DYNAMIC TABLE. It runs as a CREATE statement if the dynamic table doesn’t exist. If it does exist, it alters the dynamic table to match the definition in the statement, leaving data unchanged when possible. If the dynamic table already matches the definition, the statement is a no-op.
For more information, see CREATE OR ALTER <object> and CREATE DYNAMIC TABLE.
Release notes change log¶
| Announcement | Update | Date |
|---|---|---|
| Release notes | Initial publication (preview) | Aug 3, 2026 |
| CREATE OR ALTER DYNAMIC TABLE (General availability) | Added to Data pipeline updates | Aug 3, 2026 |
| Release notes | Final publication | Aug 6, 2026 |