本文へスキップ
Kitbay
スキル

mssql-to-snowflake-dbt-migration

MIT2026年10月27日 更新135GitHubスタースクリプトあり

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.

スキルの内容

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.

できること

  • 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