10.18 Release Notes (Preview)¶

SQL updates¶

New DEFAULT_PYTHON_ARTIFACT_REPOSITORY parameter¶

With this release, the new DEFAULT_PYTHON_ARTIFACT_REPOSITORY object parameter sets the default artifact repository used to resolve Python packages in newly created Python UDFs, UDTFs, UDAFs, and stored procedures. When the parameter is set, functions and procedures that specify PACKAGES but do not explicitly specify ARTIFACT_REPOSITORY use this default repository.

The parameter can be set at the account, database, or schema level. The priority order for repository resolution is: function-level, schema-level, database-level, account-level.

The supported value is snowflake.snowpark.pypi_shared_repository, which sources packages from PyPI. For example, to use PyPI as the default repository for the entire account, run:

ALTER ACCOUNT SET DEFAULT_PYTHON_ARTIFACT_REPOSITORY = snowflake.snowpark.pypi_shared_repository;

For more information, see Parameters.

New PROCEDURE SCOPED TEMP TABLE syntax for stored procedures¶

With this release, you can now create a temporary table that exists only for the duration of a single execution of a stored procedure. Inside the procedure body, use CREATE OR REPLACE PROCEDURE SCOPED TEMP TABLE instead of CREATE TEMPORARY TABLE. The table is automatically dropped when the procedure execution ends, rather than persisting for the rest of the session.

For syntax and details, see Procedure-scoped temporary tables (Snowflake Scripting). For an overview of when to use procedure-scoped temporary tables, see Procedure-scoped temporary tables.

Release notes change log¶