Build Snowflake data pipelines
snowflake-developmentskillsetup L3★17,464
alirezarezvani/claude-skills ↗What it does
Write Snowflake SQL, build data pipelines, and use Cortex AI
Best for
Build low-latency data transformations and AI-powered agents on Snowflake without external orchestration
Inputs
- · SQL queries or DDL
- · Data pipeline type (Dynamic Tables, Streams+Tasks, Snowpipe)
- · Cortex AI function specs
Outputs
- · Snowflake SQL definitions
- · Dynamic Table with incremental refresh
- · Stream+Task pipeline
- · Cortex Agent spec JSON
Requires
- · Snowflake account
- · Snowpark Python (optional)
- · dbt for Snowflake (optional)
Preconditions
Snowflake credentials; warehouse provisioned; data available in tables
Failure modes
Colon-prefix missing in procedures (invalid identifier error); Dynamic Table schema changes break incremental; Cortex API errors
Trust signals
- · Covers critical Snowflake quirks (colon-prefix rule, VARIANT handling)
- · Snowpark Python + dbt integration documented
- · Cortex Agents spec patterns included