Preview — 9.14 Release Notes¶

Search optimization: Support for Apache Iceberg™ tables¶

With this release, search optimization can improve the performance of queries on Iceberg tables. To configure search optimization for an Iceberg table, use ALTER ICEBERG TABLE … ADD SEARCH OPTIMIZATION.

Query Acceleration Service: Support for Apache Iceberg™ tables¶

With this release, we are pleased to announce support for the Query Acceleration Service (QAS) for Iceberg tables. The QAS accelerates scan performance and inserts on Iceberg tables. When you use a QAS-enabled warehouse to query an Iceberg table, QAS accelerates the query if it’s eligible for acceleration.

As a result of this change, QAS might incur additional credits.

Data types: Structured types support for standard Snowflake tables — Preview¶

With this release, you can define a structured type column in a standard Snowflake table.

Triggered tasks: Support for streams hosted on directory tables and data shares¶

With this release, you can now use triggered tasks to call stored procedures whenever there are changes in a stream hosted on a directory table or data share.

If the directory table is configured to auto-refresh, the triggered task runs automatically. Otherwise, in order to trigger the task, you must also refresh the directory table metadata manually. For example, ALTER STAGE my_stage REFRESH.

Apache Iceberg™ tables: Row-level deletes for externally managed tables — General availability¶

With this release, we are pleased to announce general availability of row-level deletes support with positional delete files when external engines perform update, delete, and merge operations on externally managed Iceberg tables in Snowflake.