Retire Your Legacy ETL: Agentic Code Refactoring with dbt Wizard

Use dbt Wizard to translate legacy stored procedures and GUI-based ETL workflows into tested, documented dbt models, without starting from a blank page.

Still maintaining thousand-line stored procedures that only one person understands? Or drag-and-drop workflows locked inside tools that are expensive to license, hard to version, and impossible to test? Most teams know they need to modernize, but the cost of hand-rewriting years of business logic keeps migration stuck on the roadmap. dbt Wizard changes that.

In this live worskshop, we'll show you how dbt's agentic coding harness reads your legacy logic and turns it into modular dbt models, complete with tests, documentation, and lineage.

You'll see live migrations from four common starting points: SQL stored procedures, Informatica PowerCenter mappings, Talend jobs, and Alteryx workflows. We'll walk through how Wizard breaks monolithic logic into staging, intermediate, and mart layers, preserves the business rules buried in your old code, and validates parity against legacy outputs so you can trust the results. You'll leave knowing what a realistic migration looks like for your stack, and exactly how to get started.

What you'll walk away with

• A repeatable migration workflow: see how dbt Wizard moves from legacy code to a working dbt DAG in a single pass, including SQL, tests, and docs.
• Confidence in the output: learn how to validate migrated models against legacy results so you can prove parity before you cut over.
• Patterns for each source: understand how the approach differs for procedural SQL versus GUI-based workflow exports, and where human review still matters.
• A clear path to start: know how to scope a first migration, pick the right candidate pipelines, and use skills to apply your team's conventions.