skills.rest
devCharuzu
devCharuzuCOMMUNITY
Explore all skills by this author →
GitHub

snowflake-development

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

Updated Apr 16, 2026
Search Tags:#sql#snowflake#snowpark#dynamic-tables#streams-tasks#cortex-ai
One-click install
npx skills add https://github.com/devCharuzu/philfida-taskmanage --skill snowflake-development-devcharuzu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: snowflake-development
Source: https://github.com/devCharuzu/philfida-taskmanage/tree/main/.windsurf/skills/snowflake-development
Command: npx skills add https://github.com/devCharuzu/philfida-taskmanage --skill snowflake-development-devcharuzu

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Snowflake development teams often juggle SQL best practices, data pipeline patterns, Cortex AI integration, and Snowpark Python tooling without a single authoritative guide, leading to inconsistent implementations and slower delivery.

Core Features & Use Cases

  • Comprehensive patterns for Snowflake SQL (MERGE, semi-structured data, colon-prefix rule) and dynamic tables, streams, and Snowpipe.
  • Cortex AI function usage, agent specs, and Snowpark Python workflows for end-to-end data engineering with AI capabilities.
  • Security hardening, RBAC generation, and dbt configuration patterns to streamline deployment and governance.

Quick Start

Design and implement a starter Snowflake development project by outlining SQL patterns, data pipelines, Cortex AI usage, and dbt integration in one go.

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?▼

Snowflake data pipelines can be built using standardized templates for dynamic tables, streams, and tasks. These patterns automate incremental loading and orchestration while enforcing safe implementation practices to prevent pipeline failures.

What are the best practices for Snowflake SQL stored procedures and MERGE upserts?▼

Snowflake SQL best practices include enforcing colon-prefix rules in stored procedures and using ready-made MERGE upsert templates. This standardization ensures consistent implementations, safe semi-structured data handling, and reliable data updates across projects.

Can I use Snowpark Python and Cortex AI for intelligent data automation?▼

Yes, Snowpark Python workflows and Cortex AI functions can be integrated for intelligent data automation. The skill provides agent specs and function usage patterns to seamlessly embed AI capabilities directly into your Snowflake data engineering processes.

How do I configure dbt for Snowflake deployment and security hardening?▼

dbt configuration patterns for Snowflake deployment are provided alongside security hardening and RBAC generation templates. This combination streamlines governance, enforces secure access controls, and standardizes project deployments across data teams.

Do I need specific SQL patterns to handle semi-structured data in Snowflake?▼

Handling semi-structured data in Snowflake requires specific SQL patterns and colon-prefix rules to ensure safe parsing and querying. Standardizing these patterns prevents inconsistent implementations and accelerates data pipeline delivery.

Related Skills

Explore More Data & Analytics Skills→
sfc-gh-miwhitakersfc-gh-miwhitaker
3

snowflake-cost-visibility

Configure Snowflake budgets, resource monitors, and role-based access control.

Community
Intermediate
Snowflake-LabsSnowflake-Labs
9

dbt-cortex-pipeline

Construct dbt pipelines on Snowflake with Cortex AI services.

Official
Advanced
sfc-gh-dflipposfc-gh-dflippo
34

Snowflake CLI

Automate Snowflake CLI operations for SQL execution, app deployment, and stage management.

Community
Intermediate
erichowenserichowens
181

data-pipeline-engineer

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

Community
Advanced