Migrate stored procs with dbt Wizard

Turn a legacy stored procedure into a dbt project you can maintain, test, and build on. Use dbt Wizard to generate model layers, then validate parity with audit_helper so you can trust the migration results. Wrap up by defining a Semantic Layer metric using dbt Wizard to make the new logic consumable across tools.

Learning objectives: After this lab, you will be able to:

• Migrate a stored procedure into dbt using dbt Wizard
• Validate legacy vs. dbt outputs with audit_helper
• Define a Semantic model on top of the migrated models