Migrating Sql To Dbt · AltimateAI/data-engineering-skills
Migrate legacy SQL into modular dbt models layer by layer
Converts stored procedures, views, or raw SQL into modular staging, intermediate, and mart dbt models, checking for existing sources and validating each layer with dbt build. Useful when modernizing legacy SQL pipelines into a dbt project.
Good for
- Convert a legacy SQL view into dbt models
- Break a monolithic query into staging and mart layers
- Validate each migrated dbt layer with dbt build
- 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 migrate this legacy SQL stored procedure into modular dbt models, building and validating each layer along the way.
Make your next great thing.
Bring a question, a file, or an idea that’s not quite there yet.