dynamic-tables

Automate declarative data pipelines with Snowflake Dynamic Tables.

Updated Mar 20, 2026

Search Tags:#orchestration #etl #deduplication #data-pipelines #snowflake #dynamic-tables #incremental-refresh

Ready to run

npx skills add https://github.com/jamescha-earley/agent-skills --skill dynamic-tables

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: dynamic-tables
Source: https://github.com/jamescha-earley/agent-skills/tree/main/dynamic-tables
Command: npx skills add https://github.com/jamescha-earley/agent-skills --skill dynamic-tables

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Snowflake Dynamic Tables replace manual Streams + Tasks with declarative, self-scheduling refresh and automatic deduplication, reducing orchestration complexity and maintenance overhead.

Core Features & Use Cases

Declarative pipeline definitions that remove imperative ETL logic, enabling safer maintenance.
Automatic incremental refresh and dependency-aware scheduling across multi-stage pipelines (bronze → silver → gold).
Practical guidance for designing, monitoring, and optimizing dynamic tables in production environments.

Quick Start

Create a simple three-stage dynamic table chain from raw to gold with incremental refresh using TARGET_LAG.

Frequently Asked Questions about dynamic-tables

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do Snowflake dynamic tables simplify ETL orchestration compared to streams and tasks?▼

Snowflake dynamic tables simplify ETL orchestration by replacing manual streams and tasks with declarative, self-scheduling refresh and automatic deduplication. This removes imperative pipeline logic, reducing maintenance overhead and enabling safer dependency-aware scheduling.

How do I build a bronze to gold data pipeline using dynamic tables?▼

To build a bronze to gold data pipeline, define a declarative chain of dynamic tables with incremental refresh using TARGET_LAG. This approach automatically sequences dependencies and manages refresh schedules across multi-stage pipelines from raw ingestion to analytics.

What warehouse configuration is needed for Snowflake dynamic tables?▼

Snowflake dynamic tables require a compatible warehouse to function correctly. You must also configure proper TARGET_LAG settings to ensure incremental refresh processes align with your data pipeline scheduling and latency requirements.

Can I use dynamic tables for incremental refresh and deduplication in Snowflake?▼

Yes, you can use dynamic tables for incremental refresh and deduplication in Snowflake. They natively handle automatic deduplication and self-scheduling incremental refreshes, eliminating the need to manually build deduplication logic into your ETL pipelines.

When should I not use declarative dynamic tables for data pipelines?▼

You should not use declarative dynamic tables when your data pipelines require highly customized imperative ETL logic outside standard dependency sequencing. Additionally, lack of a compatible warehouse or inability to define TARGET_LAG makes them unsuitable.