Altimate Code Launch: SQL Server to Snowflake Migration with dbt — Live Demo
Altimate Code migrated SQL Server stored procedures to dbt on Snowflake, validated the output with data diff, and generated a dashboard to prove it worked.
OVERVIEW
Migrating stored procedures from SQL Server to a modern dbt and Snowflake stack is one of the most common (and most painful) projects in data engineering. It's not just a translation problem. It's a validation problem. How do you prove the migrated models produce the same results as the original procedures?
This live demo from the Altimate Code launch event walks through the full migration lifecycle. Starting from SQL Server stored procedures, Altimate Code reads the business logic, generates dbt models across staging, silver, gold, and analytics layers, and follows a custom migration best-practices guide to ensure the output matches team standards. The raw layer is already in Snowflake via dbt seed. The focus is entirely on rebuilding the transformation layer.
Validation happens at three levels: compilation, row-count comparison between SQL Server and Snowflake, and a column-level data diff using Altimate Code's built-in diff skill. When schema mismatches are found, they're fixed in place. When the migration is done, the agent generates an interactive HTML dashboard showing migration status, validation results, model lineage, and KPIs, the kind of artifact that makes stakeholders actually trust a migration instead of just taking the engineer's word for it.
WHAT YOU'LL LEARN
- →How to structure a SQL Server to Snowflake migration using dbt and a medallion architecture
- →How to use data diff to validate that migrated models produce the same results
- →How to provide migration best-practice guides to shape the agent's output
- →How to generate a migration validation dashboard for stakeholder sign-off
KEY POINTS
- Reads SQL Server stored procedures and generates equivalent dbt models from scratch
- Follows a custom migration best-practices markdown guide for model structure and style
- Builds staging → silver → gold → analytics medallion layers in Snowflake
- Validates with row-count comparison and column-level data diff between databases
- Generates an interactive HTML dashboard: status, KPIs, lineage, and validation results
