skills.rest
pkoka888
pkoka888COMMUNITY
Explore all skills by this author →
GitHub

dbt-migration

Classify and triage dbt migration errors across platforms.

1|Updated Apr 6, 2026
Search Tags:#migration#dbt#sql#triage#compile#unit-tests#fusion
One-click install
npx skills add https://github.com/pkoka888/server-infra-templates --skill dbt-migration
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt-migration
Source: https://github.com/pkoka888/server-infra-templates/tree/main/.kilo/skills/marketplace/dbt-migration
Command: npx skills add https://github.com/pkoka888/server-infra-templates --skill dbt-migration

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about dbt-migration

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

FAQPage Schema
How do I triage dbt migration errors when moving to dbt Fusion?▼

Triage dbt migration errors by reproducing compilation issues with dbt compile or dbtf compile, reviewing dbt-autofix changes, and classifying issues into Auto-Fixable, Guided Fixes, Needs Input, or Blocked categories. This classification helps prioritize deterministic fixes for your dbt project migration.

What is the best way to migrate a dbt project from Snowflake to Databricks?▼

Migrating a dbt project from Snowflake to Databricks involves generating unit tests on the source, switching targets in profiles.yml, resolving SQL/YAML/package incompatibilities, and running final verification compilations. Using dbt Fusion for compilation helps identify and fix dialect issues during the cross-platform migration.

Can I use dbt-autofix to resolve SQL and YAML incompatibilities during a platform migration?▼

Yes, dbt-autofix can be used to resolve SQL and YAML incompatibilities during a platform migration. The migration workflow involves running dbt-autofix checks, reviewing proposed diffs for approval, and applying safe automatic fixes before validating the compilation output on the target platform.

Why does my dbt compile fail when switching targets between BigQuery and Snowflake?▼

dbt compile fails when switching targets between BigQuery and Snowflake due to SQL dialect issues, YAML configuration incompatibilities, or missing package dependencies. Reproduce the compilation errors using dbt compile, review git history for changes, and classify the findings to apply validated fixes.

Do I need CLI access to dbt and dbt-autofix to classify migration errors?▼

Yes, you need CLI access to dbt or dbtf to reproduce compilation errors and classify migration issues. Optional git history and dbt-autofix availability enhance the triage process by providing additional context for proposing validated fixes to SQL, YAML, and package configuration files.

Related Skills

Explore More Data & Analytics Skills→
clawdataclawdata
24

dbt

Manage dbt projects by orchestrating models, tests, docs, and packages via the dbt CLI.

Official
Advanced
randoneeringrandoneering

migrating-dbt-project-across-platforms

Migrates a dbt project between Snowflake and Databricks using dbt Fusion's real-time compilation to fix SQL dialect differences.

Community
Advanced
pkoka888pkoka888
1

migrating-dbt-core-to-fusion

Classify dbt-core to Fusion migration errors into four actionable categories.

Community
Advanced
kyle-chalmerskyle-chalmers
11

migrating-dbt-project-across-platforms

Migrate dbt projects across platforms using dbt Fusion to fix SQL dialect differences.

Community
Advanced