November 12, 2024 — Dynamic tables: Support for reading from Snowflake-managed Iceberg tables and creating dynamic Apache Iceberg™ tables –— General Availability¶
We are pleased to announce the general availability of the following new capabilities related to dynamic tables and Snowflake-managed Apache Iceberg™ tables:
Creating a dynamic table that reads from a Snowflake-managed Iceberg table as the source, just like regular tables.
Creating a dynamic Iceberg table, a new dynamic table type that stores query results in the Iceberg table format.
You can use dynamic Iceberg tables for the following scenarios:
Data lake integration: You can store large datasets cost-effectively while performing transformations and analytics within Snowflake, leveraging the Iceberg format for efficient querying and management.
Defining continuous data transformation pipelines: By using dynamic tables, you can ensure data is always up to date without manual intervention and handle high-velocity data streams efficiently with incremental processing.
For more information, see Create dynamic Apache Iceberg™ tables and Introduction to Streams.