snowflake-dbt-model-refactoring SKILL.md skillA
snowflake-dbt-model-refactoring from altimateai/data-engineering-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add altimateai/data-engineering-skills/snowflake-dbt-model-refactoring@git:20261015.01c534aPins git:20261015.01c534a in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- altimateai/data-engineering-skills
- Path
skills/snowflake/snowflake-dbt-model-refactoring/SKILL.md- Versions recorded
- 1
- Latest version
- git:20261015.01c534a, committed Oct 15, 2026
- Size
- 37,115 bytes
- Repository stars
- 129
- License
- MIT
Refactor a bloated dbt model on Snowflake safely and produce a quantified before/after report that explains **which qualities improved and why** — not just raw deltas. Extends the standard refactor flow with (1) downstream impact analysis via `dbt-analyze`, (2) row-count + column-hash parity validation via `data-parity`, (3) a report that lands a Bottleneck Summary and an "Outcome axes improved" table (readability, maintainability, performance, cost, governance, best-practices), and (4) an…
Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.
What the file says
# 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. ## Non-goals - Do **not** rewrite for performance alone — that is the job of `query-optimize` - Do **not** change model outputs — refactoring must preserve row count and per-row values - Do **not** touch models the user did not point at, even if they look messy ## Prerequisites & invocation This skill delegates specialized sub-tasks (lineage, parity, SQL review, cost attribution, etc.) that are not themselves packaged with `snowflake-skills`. Two valid invocation paths — pick the one that matches the user's environment: …
Read the whole file at its exact version.
How to install
mdr add altimateai/data-engineering-skills/snowflake-dbt-model-refactoring@sha256:81f01b3e250d65b7The line at the top of this page pins the label git:20261015.01c534a, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.
[](https://markdownregistry.com/a/art_enby2clyeb25p3fd)
0 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 1 version of this file, committed on Oct 15, 2026.
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (37115 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
altimateai/data-engineering-skills · 129 stars · license MIT · pushed 2026-10-23 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_enby2clyeb25p3fd GET https://markdownregistry.com/api/v1/resolve?ref=altimateai/data-engineering-skills/snowflake-dbt-model-refactoring GET https://markdownregistry.com/api/v1/blob/81f01b3e250d65b7f00c6e2f9e415a127e50622926821d8ff1ebe3ae37118047
Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.
Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.