migrating-dbt-core-to-v2

Triages dbt-core to dbt v2 migration errors into actionable fix categories.

726|62|Updated Jan 8, 2026
One-click install
npx skills add https://github.com/dbt-labs/dbt-agent-skills --skill migrating-dbt-core-to-v2-dbt-labs
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: migrating-dbt-core-to-v2
Source: https://github.com/dbt-labs/dbt-agent-skills/tree/main/skills/dbt-migration/skills/migrating-dbt-core-to-v2
Command: npx skills add https://github.com/dbt-labs/dbt-agent-skills --skill migrating-dbt-core-to-v2-dbt-labs

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Migrating a dbt project from dbt-core to dbt v2 produces dozens of unfamiliar errors, and users cannot tell which ones they can fix themselves versus which are blocked on v2 engine updates. This Skill runs dbt-autofix first, then classifies every remaining error into four actionable categories so migration work proceeds in the right order. ## Core Features & Use Cases - Mandatory triage procedure: Enforces a strict execution order — optional dbt debug credential check, dbt-autofix run with git diff review, then error classification — before any manual fixes are proposed. - Four-category classification framework: Sorts errors into auto-fixable (quote nesting, static analysis in analyses/), guided fixes with diffs (config API changes, source name mismatches, case-sensitive identifiers), needs-user-input (hardcoded FQNs, failing analyses), and blocked-on-v2 (engine gaps, MiniJinja differences, adapter methods not implemented). - GitHub issue lookup: Proactively searches dbt-labs/dbt-fusion issues via the GitHub API for suspected v2 engine bugs and links them in the report. - Use Case: A data engineer upgrades to dbt v2 and dbt compile --static-analysis strict fails with 15 errors. The Skill runs autofix, reviews its changes, then reports 4 auto-fixable issues, 6 guided fixes with diffs, 2 needing decisions, and 3 blocked on tracked v2 issues. ## Quick Start Help me triage the errors from migrating my dbt project to dbt v2 by running dbt-autofix and classifying what remains.

Frequently Asked Questions about migrating-dbt-core-to-v2

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I migrate a dbt-core project to dbt v2?▼

Run dbt-autofix first to automatically resolve common deprecation patterns, then classify remaining errors by category. Auto-fixable issues like quote nesting can be fixed directly, guided fixes need diff approval, and engine gaps require waiting for v2 updates.

What does dbt-autofix fix during a dbt v2 migration?▼

dbt-autofix automatically fixes common deprecation patterns, moves unrecognized config keys into meta sections, and upgrades packages that require it. Review its git diff afterward, since some transformations can introduce placement issues or new errors.

Why does dbt v2 static analysis report UnresolvedIdentifier errors?▼

UnresolvedIdentifier errors often come from case-sensitive quoted identifiers, where reserved words like "default" must match the real stored column casing. Verify against INFORMATION_SCHEMA.COLUMNS on the live warehouse before assuming it is a v2 engine bug.

Should I ignore dbt1065 package compatibility warnings in dbt v2?▼

Yes, dbt1065 warnings stating a package requires dbt version below 2.0.0 are not errors. dbt-autofix already upgrades packages that need it, so persistent dbt1065 warnings after autofix require no manual package updates.

When is it safe to set static_analysis off on a production dbt model?▼

Only after verifying against the live warehouse that the error is a stale cache artifact, not a real column mismatch. Suppressing an unverified error turns a compile-time failure into a silent production failure, so scope it per-model with explicit sign-off.