How does this skill ensure data correctness on the new platform?

It guides you through generating unit tests on your source platform to capture expected outputs, which must then pass on the target platform to prove migration success.

Which data platforms are supported for migration?

The skill supports any platform compatible with dbt Fusion, including major migrations like Snowflake to Databricks, Databricks to Snowflake, and more.

Do I need to manually map all SQL differences before starting?

No, this skill leverages dbt Fusion’s real-time compilation to flag specific dialect errors as you work, eliminating the need for exhaustive pre-migration documentation.

Will running migration checks incur high warehouse costs?

No, the workflow prioritizes 'dbtf compile', which is a free static analysis check. Warehouse queries are only executed during the final stages of unit testing and model materialization.

Cross-Platform dbt Migration

Name: Cross-Platform dbt Migration
Author: dbt-labs

bydbt-labs

•

304

•

데이터베이스 관리

Migrates dbt projects between data platforms like Snowflake and Databricks using real-time SQL dialect conversion and validation.

This skill provides a structured framework for migrating dbt projects across different data warehouses, leveraging dbt Fusion's real-time compilation to instantly identify and resolve SQL dialect differences. It guides developers through a rigorous 7-step workflow that includes generating 'golden dataset' unit tests on the source platform, iteratively fixing compilation errors on the target platform, and validating data correctness to ensure a seamless transition with minimal manual SQL rewriting.

주요 기능

01Cost-efficient validation using metadata-only compilation before warehouse execution

02304 GitHub stars

03Standardized migration reporting with automated change documentation

04Real-time SQL dialect error detection using dbt Fusion diagnostics

05Iterative debugging workflow to resolve platform-specific SQL patterns

06Automated 'golden dataset' unit test generation for logic validation

사용 사례

01Migrating an enterprise dbt project from Snowflake to Databricks SQL

02Refactoring legacy dbt codebases for multi-platform compatibility

03Switching data warehouse providers while maintaining 100% logic parity

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dbt-labs/dbt-agent-skills migrating-dbt-project-across-platforms

For use in Claude.ai and ChatGPT

Download Skill