dbt-migration

What problem does it solve?

This Skill reduces the complexity and risk of migrating dbt projects between platforms or to dbt Fusion by reproducing compilation errors, triaging issues, and guiding deterministic fixes so migrations complete with validated compilations and unit tests.

Core Features & Use Cases

• Error Classification & Triage: Reproduces errors using dbt/dbtf, reviews dbt-autofix changes and git history, and classifies issues into Auto-Fixable, Guided Fixes, Needs Input, or Blocked (Fusion engine gaps).
• Guided Remediation & Validation: Provides diffs for approval, recommends safe automatic fixes, enforces re-run of the repro command for validation, and documents migration changes.
• Cross-Platform Migration Workflow: Walks users through generating unit tests on the source, switching targets (profiles.yml), resolving SQL/YAML/package incompatibilities, and final verification on targets like Snowflake, Databricks, or BigQuery.
• Use Case: Migrate a production dbt project from Snowflake to Databricks using dbt Fusion for compilation, fixing dialect issues, and validating with unit tests.

Quick Start

Ask the assistant to run dbt-autofix, then run dbtf compile (or dbt compile if using Fusion as dbt) against the target and provide the compile output for classification.