9.23 Release notes: Aug 11, 2025-Aug 15, 2025¶

Snowflake Scripting 用户定义的函数 (UDFs)¶

在此版本中，您可以创建包含 Snowflake Scripting 过程语言的 SQL UDFs。Snowflake Scripting UDFs 可以在 SQL 语句中调用，例如 SELECT 语句或 INSERT 语句。因此，它们比 Snowflake Scripting 存储过程更灵活，后者只能通过 SQL CALL 命令调用。

For more information, see Snowflake Scripting UDFs.

Private facts and metrics in semantic views¶

If you are defining a fact or metric only for use in calculations in the semantic view and you don't want the fact or metric to be returned in a query, you can specify the PRIVATE keyword to mark the fact or metric as private.

Facts and metrics that are marked as private cannot be queried or used in a query condition.

For information, see Marking a fact or metric as private.

Apache Arrow 库升级到版本 v.21.0.0¶

Snowflake 9.23 升级到 Apache Arrow v.21.0.0，用于卸载 Apache Parquet 数据。

如果您的数据处理管道使用第三方工具读取 Snowflake 编写的 Parquet 文件，则建议您验证与更新后的 Apache Arrow 版本的兼容性。

Dynamic tables: Support for UNION in incremental refresh mode¶

The UNION set operator is now supported with dynamic table incremental refresh, which works like the combination of the UNION ALL and SELECT DISTINCT operators.

Other set operators are not currently supported. For a complete list, see 增量和完全刷新模式下支持的查询.