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.

About

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

Applies explicit type casting and precision mappings to ensure data parity across platforms
25 GitHub stars
Recommends optimal Snowflake materialization strategies and clustering keys
Generates complete dbt schema.yml files with automated tests, documentation, and relationships
Translates DB2-specific syntax like FETCH FIRST and Inline SQL PL to Snowflake equivalents
Refactors complex procedural logic into modular, declarative dbt models

Use Cases

Migrating legacy IBM DB2 database objects to a modern Snowflake and dbt data stack
Standardizing raw SQL DDL into dbt-ready models with consistent naming and documentation
Refactoring DB2 stored procedures into maintainable, version-controlled dbt models

About

Key Features

Applies explicit type casting and precision mappings to ensure data parity across platforms
25 GitHub stars
Recommends optimal Snowflake materialization strategies and clustering keys
Generates complete dbt schema.yml files with automated tests, documentation, and relationships
Translates DB2-specific syntax like FETCH FIRST and Inline SQL PL to Snowflake equivalents
Refactors complex procedural logic into modular, declarative dbt models

Use Cases

Migrating legacy IBM DB2 database objects to a modern Snowflake and dbt data stack
Standardizing raw SQL DDL into dbt-ready models with consistent naming and documentation
Refactoring DB2 stored procedures into maintainable, version-controlled dbt models