Will it generate dbt tests for my columns?

Yes, the skill produces schema.yml files that include unique, not_null, and relationship tests derived from the source DDL constraints.

How does it handle DB2-specific functions?

It automatically maps DB2 functions like SUBSTR, LOCATE, and CURRENT DATE to their direct Snowflake equivalents using a comprehensive translation reference.

Does it handle complex data type mapping?

Absolutely. It maps DB2 types like CLOB to VARCHAR and XML to Snowflake VARIANT, while enforcing explicit precision and scale using Snowflake's casting syntax.

Does this skill support DB2 stored procedure conversion?

Yes, it refactors DB2 stored procedures and compound statements into modular dbt models or Snowflake Scripting, favoring declarative SQL where possible.

DB2 to Snowflake dbt Migrator

Name: DB2 to Snowflake dbt Migrator
Author: sfc-gh-dflippo

bysfc-gh-dflippo

•

Database Management

Converts IBM DB2 DDL and stored procedures into production-ready dbt models and schema configurations optimized for Snowflake.

This skill accelerates data warehouse modernization by translating legacy IBM DB2 objects—including views, tables, and complex stored procedures—into modular dbt models compatible with the Snowflake Data Cloud. It handles the heavy lifting of SQL syntax conversion, transforming procedural SQL PL into declarative dbt code, mapping specific data types, and applying Snowflake-optimized functions. By automatically generating comprehensive schema.yml files with built-in tests and documentation, it ensures that migrated code follows modern data engineering best practices while preserving critical business logic and data integrity.

Key Features

01Applies explicit type casting and precision mappings to ensure data parity across platforms

0225 GitHub stars

03Recommends optimal Snowflake materialization strategies and clustering keys

04Generates complete dbt schema.yml files with automated tests, documentation, and relationships

05Translates DB2-specific syntax like FETCH FIRST and Inline SQL PL to Snowflake equivalents

06Refactors complex procedural logic into modular, declarative dbt models

Use Cases

01Migrating legacy IBM DB2 database objects to a modern Snowflake and dbt data stack

02Standardizing raw SQL DDL into dbt-ready models with consistent naming and documentation

03Refactoring DB2 stored procedures into maintainable, version-controlled dbt models

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sfc-gh-dflippo/snowflake-dbt-demo dbt-migration-db2

For use in Claude.ai and ChatGPT

Download Skill