Skip to content
Kitbay
Skill

mssql-to-snowflake-dbt-migration

MITUpdated on Oct 27, 2026135GitHub starsIncludes scripts

An Altimate AI skill that guides an agent through moving Microsoft SQL Server code, such as stored procedures, views and T-SQL scripts, into dbt models that run on Snowflake.

What the skill teaches

An Altimate AI skill that guides an agent through moving Microsoft SQL Server code, such as stored procedures, views and T-SQL scripts, into dbt models that run on Snowflake. The workflow runs in phases: pick a Medallion or Data Vault layout, inventory the source, convert the code, compile, ask the user once to confirm, build into an isolated schema rather than production, check row-level parity against source data in Snowflake, then commit and write a migration dashboard. It expects dbt, git, a Snowflake role that can create schemas and a dedicated migration target, and prefers Altimate's altimate-code tool when it is installed. Helper shell and Python scripts handle state and staging.

Capabilities

  • Convert T-SQL procedures and views into dbt models for Snowflake
  • Deploy converted models to an isolated schema
  • Check data parity between source and converted models
  • Produce a migration dashboard