snowflake-development
Comprehensive Snowflake development assistant covering SQL best practices, data pipeline design (Dynamic Tables, Streams, Tasks, Snowpipe), Cortex AI functions, Cortex Agents, Snowpark Python, dbt integration, performance tuning, and security hardening.
Profile →npx skills add sickn33/agentic-awesome-skills --skill snowflake-development --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Snowflake Development You are a Snowflake development expert. Apply these rules when writing SQL, building data pipelines, using Cortex AI, or working with Snowpark Python on Snowflake. ## When to Use - When the user asks for help with Snowflake SQL, data pipelines, Cortex AI, or Snowpark Python. - When you need Snowflake-specific guidance for dbt, performance tuning, or security hardening. ## SQL Best Practices ### Naming and Style - Use `snake_case` for all identifiers. Avoid double-quoted identifiers — they create case-sensitive names requiring constant quoting. - Use CTEs (`WITH` clauses) over nested subqueries. - Use `CREATE OR REPLACE` for idempotent DDL. - Use explicit column lists — never `SELECT *` in production (Snowflake's columnar storage scans only referenced columns). ### Stored Procedures — Colon Prefix Rule In SQL stored procedures (BEGIN...END blocks), variables and parameters **must** use the colon `:` prefix inside SQL statements. Without it, Snowflake raises "invalid identifier" errors. BAD: ```sql CREATE PROCEDURE my_proc(p_id INT) RETURNS STRING LANGUAGE SQL AS BEGIN LET result STRING; SELECT name INTO result FROM users WHERE id = p_id; RETURN result; END; `
- When to Use
- SQL Best Practices
- Naming and Style
- Stored Procedures — Colon Prefix Rule
- Semi-Structured Data
- MERGE for Upserts
- Data Pipelines
- Choosing Your Approach
- Dynamic Tables
- Streams and Tasks
- Cortex AI
- Function Reference
- TOFILE — Common Error Source
- Use AICLASSIFY for Classification (Not AICOMPLETE)
What does the snowflake-development skill do?
Comprehensive Snowflake development assistant covering SQL best practices, data pipeline design (Dynamic Tables, Streams, Tasks, Snowpipe), Cortex AI functions, Cortex Agents, Snowpark Python, dbt integration, performance tuning, and security hardening.
How do I install it?
Run `npx skills add sickn33/agentic-awesome-skills --skill snowflake-development --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From sickn33/agentic-awesome-skills, a repository with 44,414 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.