Refactoring SQL for Modularity
Learn with the analytics engineers of dbt Labs how to migrate legacy transformation code into modular dbt data models. Useful if you're porting stored procedures or SQL scripts into your dbt project. (approximately 3.5 hours)
Introduction (5 min)
Part 1: Learn the refactoring process (80 min)
Setting up your Environment (15 min)
Part 2: Practice refactoring (90 min)
Practice Overview Exemplar: Migrate Legacy Code Exemplar: Implementing sources and choosing your refactoring strategy Exemplar: Cosmetic cleanups and CTE groupings Exemplar: Centralizing Logic and splitting up models Exemplar: Auditing Refactoring SQL for Modularity - One Pager Quick survey Congratulations!