Skip to main content

Snowflake Development

Plugin Verified Active

Snowflake SQL, data pipelines (Dynamic Tables, Streams+Tasks), Cortex AI functions, Snowpark Python, and dbt integration. Includes query helper script, 3 reference guides, and troubleshooting.

1 Skill 0 MCPs
Purpose

To empower developers working with Snowflake by providing specialized tools, best practices, and troubleshooting guidance for SQL, data pipelines, AI functions, Snowpark, and dbt.

Features

  • Snowflake SQL development assistance
  • Data pipeline creation (Dynamic Tables, Streams+Tasks)
  • Cortex AI function integration
  • Snowpark Python development support
  • dbt integration for Snowflake

Use Cases

  • Writing complex Snowflake SQL queries with best practices
  • Building and managing near real-time data pipelines
  • Integrating AI capabilities into Snowflake workflows
  • Developing and deploying Python code within Snowflake
  • Configuring and optimizing dbt projects for Snowflake

Non-Goals

  • Managing Snowflake infrastructure beyond code and pipeline definitions
  • Providing generic Python development tools outside of Snowpark context
  • General-purpose SQL dialect support for databases other than Snowflake

Workflow

  1. Generate SQL templates (MERGE, Dynamic Tables, RBAC)
  2. Implement data pipelines using Dynamic Tables or Streams/Tasks
  3. Integrate Cortex AI functions for data enrichment
  4. Develop and deploy Snowpark Python code
  5. Configure dbt models for Snowflake

Practices

  • SQL Best Practices
  • Data Pipeline Design
  • AI Integration
  • Secure Coding

Prerequisites

  • Python 3
  • Snowflake account access
  • dbt CLI (for dbt integration)

Code Execution

  • info:ValidationThe `snowflake_query_helper.py` script likely performs some validation on its inputs (table names, columns) for generating SQL, but a formal schema library (like Zod or Pydantic) is not explicitly evident from the provided files.

Installation

/plugin install snowflake-development@alirezarezvani-claude-skills

Quality Score

Verified
98 /100
Analyzed about 24 hours ago

Trust Signals

Last commit1 day ago
Stars14.6k
LicenseMIT
Status
View Source

© 2025 SkillRepo · Find the right skill, skip the noise.