dynamic-tables-tutorial
OfficialHands-on Dynamic Tables: build fresh pipelines
Data & Analytics#tutorial#data pipelines#snowflake#cdc#dynamic tables#incremental refresh#cortex code
AuthorSnowflake-Labs
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Snowflake Dynamic Tables reduce the complexity of building and maintaining CDC pipelines by replacing streams, tasks, and merge logic with a declarative, automatically refreshed table. This Skill solves the pain of writing, scheduling, and debugging multi-object pipelines while ensuring near-real-time freshness with minimal operational overhead.
Core Features & Use Cases
- Step-by-step hands-on lessons covering data loading, dynamic table creation, incremental refresh, materialized view migration, CDC comparisons, monitoring, and cleanup.
- Teaching safeguards and patterns such as explain-before-execute, pause-for-confirmation, environment detection (SNOWFLAKE_LEARNING fallback), and verification checks to prevent accidental destructive actions.
- Real-world scenarios: convert Streams+Tasks to Dynamic Tables, demonstrate incremental refresh after new data ingestion, and build multi-stage DT pipelines for dashboards and analytics.
Quick Start
Ask the agent: teach me dynamic tables and start Lesson 1 using SNOWFLAKE_LEARNING if available.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: dynamic-tables-tutorial Download link: https://github.com/Snowflake-Labs/sfguides/archive/main.zip#dynamic-tables-tutorial Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.