skills.rest
kyle-chalmers
kyle-chalmersCOMMUNITY
Explore all skills by this author →
GitHub

migrating-dbt-project-across-platforms

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

11|3|Updated Mar 9, 2026
Search Tags:#cross-platform#dbt#migrate#unit-tests#snowflake#databricks#fusion
One-click install
npx skills add https://github.com/kyle-chalmers/dbt-agentic-development --skill migrating-dbt-project-across-platforms-kyle-chalmers
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: migrating-dbt-project-across-platforms
Source: https://github.com/kyle-chalmers/dbt-agentic-development/tree/main/.agents/skills/migrating-dbt-project-across-platforms
Command: npx skills add https://github.com/kyle-chalmers/dbt-agentic-development --skill migrating-dbt-project-across-platforms-kyle-chalmers

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Migrating dbt projects between data platforms (e.g., Snowflake to Databricks) requires harmonizing SQL dialects and validating model behavior on the target. This Skill leverages dbt Fusion's real-time compilation to identify dialect differences and guide the migration workflow.

Core Features & Use Cases

  • End-to-end cross-platform migration workflow: verify Fusion installation, compile on source, generate unit tests, switch to the destination profile, recompile on target, and run tests to validate both compilation and data behavior.
  • Guidance and resources: provides references for installation, unit tests generation, and switching targets, ensuring a repeatable, auditable migration process.
  • Safety and validation: emphasizes compiling with Fusion before running warehouse operations to minimize cost and risk, and verifying unit tests on the target platform before final validation.

Quick Start

Begin by verifying dbt Fusion is installed and connected, then follow the Migration Workflow to migrate the project from the source platform to the destination platform.

Frequently Asked Questions about migrating-dbt-project-across-platforms

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

FAQPage Schema
How do I migrate a dbt project from Snowflake to Databricks?▼

Migrate a dbt project from Snowflake to Databricks by using dbt Fusion to compile the source, generate unit tests, switch to the destination profile, recompile on the target, and run tests to validate behavior.

What is the best way to identify SQL dialect differences when migrating dbt projects?▼

Identify SQL dialect differences during cross-platform dbt migrations by using dbt Fusion's real-time compilation, which detects incompatibilities before you execute any warehouse operations on the target platform.

Does dbt Fusion support cross-platform migrations without running warehouse operations?▼

Yes, dbt Fusion supports cross-platform migrations by enforcing compilation-first validation, allowing you to identify and fix SQL dialect differences and confirm success before running costly warehouse operations.

How do I generate and run unit tests when switching dbt project targets?▼

Generate unit tests on your source platform first, then switch dbt targets to the destination profile and recompile. Confirm migration success by running these unit tests and model runs on the target platform.

What are the steps to validate a dbt migration using dbt Fusion?▼

Validate a dbt migration by installing dbt Fusion, compiling on the source to find dialect issues, generating unit tests, switching targets, recompiling on the destination, and confirming success through unit tests and model runs.

Related Skills

Explore More Data & Analytics Skills→
memadorememadore

migrating-dbt-project-across-platforms

Migrate dbt projects across data platforms using dbt Fusion compilation.

Community
Advanced
juandaniel190juandaniel190
1

migrating-dbt-project-across-platforms

Migrate dbt projects across data platforms using dbt Fusion compilation and unit tests.

Community
Advanced
pkoka888pkoka888
1

migrating-dbt-project-across-platforms

Migrate dbt projects across data platforms using dbt Fusion compilation.

Community
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