Convert a legacy SQL script or view into a dbt model and prove parity
When a scheduled SQL script is the real production logic and nobody can prove a rebuild would match it.
- Transformation
Larger outcome
9 RecipesLegacy data-stack re-engineering
Everything you own that still works and nobody wants to touch: stored procedures, views, notebooks, scalar functions and managed connectors. Each one is rebuilt with parity proved rather than assumed.
Convert a stored procedure into a dbt model and prove parity
When the nightly load is a stored procedure nobody fully understands anymore.
- Transformation
Convert a materialized view into a dbt model and preserve its required refresh semantics
When a materialized view refreshes on a schedule nobody wrote down and downstream reports assume that cadence.
- Transformation
Convert a notebook transformation into a dbt model and prove parity
When a transformation only exists as a notebook someone runs by hand before the numbers go out.
- Transformation
Convert a Spark ingestion notebook into a dlt pipeline and prove landed parity
When a Spark notebook is the only thing that lands a source into bronze and nobody can run it unattended.
- Ingestion
Convert a scalar SQL function into a dbt macro and prove equivalence
When a scalar SQL function is called from a dozen models and lives outside version control.
- Transformation
Replace a Fivetran or Airbyte connector with a dlt pipeline and reconcile the result
When the connector bill changed shape, or the connector has been broken with a pending fix for weeks.
- Ingestion
Move a dbt project to a new destination and prove parity before cutover
When the warehouse is changing and the dbt project has to follow it.
- Transformation
Assess a Synapse dedicated pool or SSIS estate for a rebuild on Fabric
When Fabric is the mandate and the estate is hundreds of packages nobody wants to open.
- Governance and cost