cyberneticlibrary
← library

Build Snowflake pipelines and SQL queries

snowflake-developmentpluginsetup L2★17,464
alirezarezvani/claude-skills ↗
What it does

Build and optimize Snowflake SQL pipelines with Cortex AI, Streams+Tasks, and dbt integration

Best for

When building production data pipelines in Snowflake requires serverless compute, AI-native SQL functions, and dbt workflow management.

Inputs
  • · raw data in Snowflake
  • · pipeline requirements: streaming, batch, or real-time
  • · dbt project or SQL directory
Outputs
  • · Dynamic Tables + Streams+Tasks pipelines
  • · Cortex AI SQL functions (e.g., classification, sentiment)
  • · Snowpark Python transformations
  • · dbt integration + query optimization
Requires
  • · Snowflake API + SQL
  • · Cortex AI functions
  • · Snowpark SDK (Python)
  • · dbt (optional)
  • · query helper script
  • · stdlib Python tools
Preconditions
  • · Snowflake account + compute credits
  • · source data loaded in warehouse
  • · schema designed or inferred
Failure modes
  • · Dynamic Tables refresh cost explodes without proper scheduling
  • · Cortex AI functions unavailable in some regions
  • · dbt deployment mismatch between local and warehouse environments
Trust signals
  • · Snowflake API + Cortex AI + Snowpark documented
  • · dbt integration patterns included
  • · 3 reference guides + troubleshooting section
  • · query helper script for optimization