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
Prerequisites:
- dbt Fundamentals
- SQL experience
What to bring: You must bring your own laptop to complete the exercises. We will provide all other sandbox environments for dbt and a data platform.
Duration: 90 minutes
Check out more sessions
- Breakout session
From selection to scale: how ING is operationalizing dbt across a global bank
Jarno Boeijink / ING Bank N.V.View session - Peer exchange
Beyond the bottleneck: position your Analytics Engineering team as a strategic force
Kasey Mazza / HubSpotView session - Training add-on
Operationalize cost visibility in dbt
Jessica Stayton / dbt LabsJenna Bushspies / dbt LabsView session
