Skill audit report

snowflake-dbt-model-refactoring Audit report.

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 optional post-refactor warehouse benchmark against real Snowflake query history offered at the end. Use when the user says "refactor this model", "clean up this model", or points at a model that is oversized / over-joined / duplicated across the project — and the warehouse is Snowflake. Delegates to Altimate skills — does not reinvent them.

EXPERIMENTAL · REVIEWNeeds reviewGenerated Oct 19, 2026Heuristic metadata audit
76
Audit
73
Trust
63
Quality
73
Security
100
Maintain
92
Install

OpenAgentSkill Trust Score

73
Strong shortlist

OpenAgentSkill Trust Score

The Trust Score helps an agent decide whether a skill is safe enough to shortlist before installation.

GitHub adoption

INFO

62

128 GitHub stars

Stars/forks activity

WARN

57

128 stars, 11 forks; issue activity unavailable in current metadata

Recent maintenance

PASS

100

3d since push

License clarity

PASS

86

MIT

README/SKILL.md completeness

PASS

86

Metadata includes enough usage and workflow context

Dependency/runtime risk

WARN

56

command execution surface, network or browser surface

Install availability

PASS

92

npx skills add AltimateAI/data-engineering-skills --skill snowflake-dbt-model-refactoring

Install command safety

PASS

92

standard package or runtime install path

Permission surface

FAIL

36

shell or command execution, filesystem or document access

Repository evidence

PASS

86

https://github.com/AltimateAI/data-engineering-skills/tree/main/skills/snowflake/snowflake-dbt-model-refactoring

Review status

WARN

46

AI review approval is missing

Agent Proven outcomes

INFO

54

No agent outcome data yet

Checks

Install and adoption review

6 Passed · 13 Needs review

Install path

92

PASS

npx skills add AltimateAI/data-engineering-skills --skill snowflake-dbt-model-refactoring

Repository

88

PASS

https://github.com/AltimateAI/data-engineering-skills/tree/main/skills/snowflake/snowflake-dbt-model-refactoring

License

86

PASS

MIT

Maintenance

100

PASS

3d since push

AI review

55

CHECK

Review approval is missing

README/SKILL.md completeness

86

PASS

Usable description available

Dependency risk

56

FIX

command execution surface, network or browser surface

Install command safety

92

PASS

standard package or runtime install path

Permission surface

36

FIX

shell or command execution, filesystem or document access

Stars/forks activity

57

FIX

128 stars, 11 forks; issue activity unavailable in current metadata

Adoption

68

INFO

128 GitHub stars

Warnings

  • Dependency or permission surface needs review
  • Permission surface may require sandboxing
  • AI review approval is missing
  • Quality score needs review
  • Permission surface needs review: shell or command execution, filesystem or document access
  • Stars/forks activity: 128 stars, 11 forks; issue activity unavailable in current metadata
  • Dependency/runtime risk: command execution surface, network or browser surface
  • Permission surface: shell or command execution, filesystem or document access
  • Review status: AI review approval is missing

Method

This report combines public metadata, AI review output, repository freshness, install readiness, OpenAgentSkill events, quality scoring, trust checks, and the agent safety gate. It is not a full source-code security review.

Compare nearby options

Related skills to audit next