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

Snowflake Scripting user-defined functions (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.

If your data processing pipeline uses third-party tools to read Parquet files written by Snowflake, we recommend that you verify compatibility with the updated Apache Arrow version.

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 Supported queries in incremental and full refresh modes.