snowflake-dbt-model-refactoring
Installation
SKILL.md
snowflake-dbt-model-refactoring
When to invoke
Trigger this skill when any of the following is true for a target dbt model on a Snowflake-backed dbt project:
- More than ~200 lines
- More than 5 joins in a single query block
- A CTE longer than ~50 lines
- Logic duplicated across 3+ models (payment pivots, RFM buckets, etc.)
- Hardcoded lists / thresholds repeated inline
- Downstream consumers exist and would be affected by structural changes
If the project targets BigQuery, Redshift, or Databricks, use the generic
refactoring-dbt-models skill instead — Phase 7's warehouse benchmark is
Snowflake-specific.