Dynamic Tables

Dynamic Tables is the current Snowflake name, previously Materialized Tables (since June 2023).

Materialized Tables → Dynamic Tables

A table type that materializes the result of a SELECT query and keeps it up to date automatically, refreshing against a target lag instead of a schedule you maintain.

• You never write the refresh logic - you state a target lag, and Snowflake works out the dependency graph and the refresh order on your behalf. 🔗
• Its general availability note still introduced it as "a new table type", by which point it had been in public preview for ten months. 🔗

Category

Data engineering

In use from

June 2023🔗

Announced at

Snowflake Summit 2023🔗

Also known as

dynamic table, CREATE DYNAMIC TABLE

Verified

2026-09-12