April 22-24, 2024 — 8.16 Release Notes¶

Attention

The release has completed.

For differences between the in-advance and final versions of these release notes, see Release notes change log.

SQL updates¶

New SQL command(s)¶

The following commands(s) are now available with this release:

Command Category	New Command	Description
Organization DDL	SHOW ACCOUNTS	Lists all accounts in an organization, with the exclusion of managed accounts. Currently duplicates the functionality of SHOW ORGANIZATION ACCOUNTS. In a future release, the purpose and output of SHOW ORGANIZATION ACCOUNTS will change.

Command Category

New Command

Description

Organization DDL

SHOW ACCOUNTS

Lists all accounts in an organization, with the exclusion of managed accounts.

Currently duplicates the functionality of SHOW ORGANIZATION ACCOUNTS. In a future release, the purpose and output of SHOW ORGANIZATION ACCOUNTS will change.

SQL API support for hybrid tables¶

With this release, Snowflake is pleased to announce support for the Snowflake SQL API when queries and other operations access data in hybrid tables. The SQL API is a REST API that you can use to access and update data in a Snowflake database.

Extensibility updates¶

Asynchronous job support in Snowpark stored procedures¶

With this release, Snowflake is pleased to announce support for running concurrent asynchronous child jobs using Snowpark APIs within stored procedure handler code written in Java, Python, or Scala. You can run an asynchronous query, as well as access its status and result, or cancel the query.

Data Lake Updates¶

Apache Iceberg™ tables: Support for un-materialized identity partition columns¶

With this release, Snowflake is pleased to announce that you can create an Apache Iceberg™ table from an Iceberg data source that contains un-materialized identity partition columns.

An un-materialized identity partition column is created when a table defines an identity transform using a source column that doesn’t exist in a Parquet file.

Before release 8.16, this scenario was not supported.

For more information, see Apache Iceberg™ tables.

Release notes change log¶

Announcement	Update	Date
Release notes	Initial publication (preview)	22-Apr-24
Asynchronous job support in Snowpark stored procedures	Added to Extensibility updates section	23-Apr-24
Support for granting the WRITE privilege on external stages	Removed from Data loading / unloading updates section (and section removed) because this update was announced in the previous release	23-Apr-24
\|iceberg-tm\| tables: Support for un-materialized identity partition columns	Added to Data Lake Updates	26-Apr-24