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

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

With this release, you can create SQL UDFs that contain Snowflake Scripting procedural language. Snowflake Scripting UDFs can be called in a SQL statement, such as a SELECT statement or INSERT statement. Therefore, they are more flexible than a Snowflake Scripting stored procedure, which can only be called in a SQL CALL command.

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 library upgrade to version 21.0.0¶

Snowflake 9.23 upgrades to Apache Arrow 21.0.0 for unloading Apache Parquet data.

如果您的数据处理管道使用第三方工具读取 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 增量和完全刷新模式下支持的查询.