Refactoring Dbt Models · AltimateAI/data-engineering-skills
Refactor dbt models with downstream impact analysis
Guides safe restructuring of dbt SQL models, extracting long CTEs into intermediate models and repeated logic into macros, by mapping every downstream dependency first, then verifying output after each incremental change.
Good for
- Extract a long CTE into its own model
- Find all downstream consumers before changing a model
- Move repeated SQL logic into a dbt macro
- Source repository
- AltimateAI/data-engineering-skills
- Category
- General
Open-source skills are maintained by their authors and listed as published, with attribution. Results depend on how well the skill fits your task and material.
A good place to start
Help me refactor this dbt model, but first find every downstream model that depends on it.
Make your next great thing.
Bring a question, a file, or an idea that’s not quite there yet.