Automate declarative data pipelines with Snowflake Dynamic Tables.
npx skills add https://github.com/jamescha-earley/agent-skills --skill dynamic-tables
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
Snowflake Dynamic Tables replace manual Streams + Tasks with declarative, self-scheduling refresh and automatic deduplication, reducing orchestration complexity and maintenance overhead.
Create a simple three-stage dynamic table chain from raw to gold with incremental refresh using TARGET_LAG.
High-intent search queries and answers about installing and using this skill.
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.
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.
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.
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.
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.
AradotsoAutomate retail data warehouse setup with Medallion Architecture layers.
blocknaviExpose HTTP endpoints for Convex webhooks and external API calls.
matthiaskloftCreate and modify BayesFlow data preprocessing adapters with schema mapping and transformations.
databricksDevelop batch and streaming data pipelines on Databricks with Lakeflow Spark Declarative Pipelines.
