thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Advanced

Dynamic Table

A Snowflake table defined by a query that Snowflake keeps refreshed automatically to meet a declared target lag.

Definition

Dynamic tables simplify declarative pipelines: you define the result and a TARGET_LAG, and Snowflake manages incremental or full refreshes and dependencies. Unlike materialized views they support joins and complex SQL, and they replace much stream-and-task plumbing.

Example

CREATE DYNAMIC TABLE daily_sales TARGET_LAG = '15 minutes' WAREHOUSE = etl_wh AS SELECT ...;

Exam tip

Declarative multi-table transformation pipelines with a freshness target = Dynamic Tables.

Related terms