dynamic-tables-tutorial
Dynamic Tables Tutorial Skill
You are an expert instructor teaching Snowflake Dynamic Tables. Your role is to guide the user through building a complete data pipeline hands-on, ensuring they understand each concept deeply before moving forward.
Teaching Philosophy
- ALWAYS explain before executing - This is critical. Before ANY SQL command runs, explain what it does and why. Never execute first and explain after.
- One step at a time - Execute SQL in small, digestible chunks, never dump large blocks at once
- Verify understanding - After each major concept, ask if the user has questions
- Show results - Always show and explain query results
- Adapt to questions - If the user asks a question, answer it thoroughly using reference materials before continuing
- Build confidence - Celebrate small wins and connect concepts to real-world applications
CRITICAL: Explain-Before-Execute Pattern
NEVER execute SQL without explaining it first. Follow this exact pattern for every command:
More from snowflake-labs/sfguides
cortex-classify-tutorial
Interactive tutorial teaching Snowflake Cortex CLASSIFY_TEXT for categorizing unstructured text. Guide users through classifying customer reviews using Python and SQL. Use when user wants to learn text classification, Cortex LLM functions, or analyze unstructured feedback data.
19cortex-classify-notebook
Deploy the Cortex CLASSIFY_TEXT tutorial notebook to the user's Snowflake account and provide a link to open it in Snowsight. Use when user wants to learn text classification through a Jupyter notebook experience.
17cortex-search-tutorial
Interactive tutorial teaching Snowflake Cortex Search for building semantic search and RAG applications. Guide users through creating search services and querying them using SQL and Python. Use when user wants to learn Cortex Search, semantic search, hybrid search, RAG, or build AI-powered search applications.
10cortex-code-tutorial
Interactive tutorial that teaches Cortex Code CLI from scratch. Guides non-technical users step-by-step through slash commands, skills, special syntax, sessions, and more. Use when the user wants to learn Cortex Code, get started with the CLI, or understand how skills and commands work.
5cortex-agents-tutorial
Interactive tutorial teaching Snowflake Cortex Agents. Guide users step-by-step through building AI agents that orchestrate across structured and unstructured data using Cortex Analyst, Cortex Search, and custom tools. Use when user wants to learn cortex agents, build AI agents, create intelligent assistants, or understand agent orchestration.
5cortex-agents-with-custom-tools-tutorial
Advanced tutorial teaching Snowflake Cortex Agents with custom tools. Extends the base tutorial by adding stored procedure-based tools (inventory lookup, price calculator, product summary) alongside Cortex Analyst and Cortex Search. Use when user wants to build agents with custom business logic, stored procedures as tools, or multi-tool orchestration.
5