Knowledge Graph — Coursera Notes › Academic disciplines › Information Technology / Computer Science › Cloud Computing › Snowflake

Dynamic Table

feature · part of Snowflake

A table that stores precomputed query results and refreshes automatically based on a configured target lag.

Inside Dynamic Table (1)

TARGET_LAG — A parameter specifying the maximum allowed delay between source data changes and dynamic table refresh.

Connections

Alternative to Materialized View
Alternative to Standard View
Used for Snowpipe
Related to Materialized View
Related to TARGET_LAG

This is the text view of an interactive 3D knowledge graph — open this page with JavaScript enabled to explore it visually.

Select a node

The owner's editing tools — shown here so you can see how the graph is grown, but read-only.

Click a bubble to drill in · click again to collapse · drag to move around