Tag

#dynamic-tables

2 stories tagged dynamic-tables.

Snowflake Dynamic Tables refresh gets a cost test

Snowflake Dynamic Tables now claim up to 2.8x faster refresh on Gen2 warehouses, but the cost win depends on target lag and change volume.

Lars Cornelissen · Jun 22, 2026

Snowflake

Dynamic Tables vs Streams and Tasks: which Snowflake pipeline to build

Dynamic Tables let you declare a SELECT and a target lag and let Snowflake refresh it; Streams and Tasks give you imperative control. Dynamic Tables bottom out at a 60-second minimum lag, so sub-minute freshness still means Snowpipe Streaming or Tasks.

Lars Cornelissen · Jun 7, 2026