Tag

#dbt

2 stories tagged dbt.

Snowflake Dynamic Tables refresh cost pattern showing 200 tables at a 1 minute target lag producing 288000 daily change detection checks, versus 28800 at 10 minutes and 4800 at 60 minutes.

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