skills.rest
Patasse97
Patasse97COMMUNITY
Explore all skills by this author →
GitHub

snowflake-development

Automate Snowflake SQL development workflows and data pipelines.

Updated Apr 9, 2026
Search Tags:#sql#data-pipelines#snowflake#snowpark#dynamic-tables#streams-tasks#cortex-ai
One-click install
npx skills add https://github.com/Patasse97/claude-skills --skill snowflake-development
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: snowflake-development
Source: https://github.com/Patasse97/claude-skills/tree/main/engineering-team/snowflake-development
Command: npx skills add https://github.com/Patasse97/claude-skills --skill snowflake-development

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Snowflake SQL development, data pipelines, and Cortex AI integration are complex. This Skill consolidates patterns, templates, and best practices to accelerate reliable Snowflake deployments and debugging across DBT, Snowpark, and data orchestration.

Core Features & Use Cases

  • Build and optimize Snowflake SQL with patterns for MERGE, Dynamic Tables, and object-level security.
  • Assemble end-to-end data pipelines using Streams/Tasks, Snowpipe, and dynamic table orchestration.
  • Integrate Cortex AI functions, Snowpark Python, and dbt workflows to accelerate data engineering tasks.
  • Use case: Create a robust Snowflake deployment workflow with templates, references, and automated RBAC guidance.

Quick Start

Run the included helper to generate boilerplate templates for common Snowflake patterns.

Frequently Asked Questions about snowflake-development

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

FAQPage Schema
How do I build Snowflake data pipelines using Dynamic Tables and Streams?▼

Build Snowflake data pipelines by orchestrating Dynamic Tables, Streams, and Tasks to automate incremental data loading and transformations. This Skill provides standardized patterns and helper scripts to assemble reliable end-to-end pipeline workflows.

How do I integrate Snowpark Python and dbt workflows in Snowflake?▼

Integrate Snowpark Python and dbt workflows by applying standardized templates that connect dbt transformations with Snowpark Python processing. This accelerates data engineering tasks and ensures robust deployment patterns across both environments.

Can I use Cortex AI functions within my Snowflake SQL development?▼

Use Cortex AI functions within Snowflake SQL development to embed machine learning and AI processing directly in data pipelines. This Skill provides integration patterns and reference guides to implement Cortex AI functions effectively.

What is the best way to troubleshoot Snowflake errors and deployment issues?▼

Troubleshoot Snowflake errors using provided reference guides and standardized debugging patterns. The Skill includes troubleshooting references for common pipeline failures, RBAC misconfigurations, and object-level security issues to ensure robust deployments.

Does this Skill provide templates for Snowflake MERGE statements and RBAC setup?▼

Generate boilerplate templates for Snowflake MERGE statements and automated RBAC guidance using the included snowflake_query_helper.py script. This provides standardized patterns for object-level security and reliable SQL deployments.

Why use Dynamic Tables instead of Streams and Tasks for Snowflake data pipelines?▼

Dynamic Tables automate declarative data transformations, while Streams and Tasks handle incremental CDC processing and task orchestration. This Skill provides reference guides to choose and implement the appropriate pipeline pattern for your specific workload.

Related Skills

Explore More Software Engineering Skills→
4lerman4lerman

snowflake-development

Provide Snowflake SQL best practices and data pipeline management guidance.

Community
Advanced
devCharuzudevCharuzu

snowflake-development

Standardize Snowflake SQL patterns, pipelines, Cortex AI, and Snowpark Python practices.

Community
Advanced
CygnusfearCygnusfear
5

devflow

Automate end-to-end agent development workflows with phase-driven coordination and issue extraction.

Community
Advanced
erichowenserichowens
181

data-pipeline-engineer

Automate ETL/ELT pipeline design, validation, and operation across medallion architectures.

Community
Advanced