Pipeline Portability Review (Handoff)

Pipeline Portability Review (Handoff)

1. 01

   Inventory every pipeline component and tag it as open standard, vendor-managed, or proprietary

   Walk the client's ingestion, transformation, orchestration, and reverse ETL layers and label each one. A dbt project and a Spark job travel easily; a managed connector graph or an AI agent that writes DAGs does not.

2. 02

   Score each proprietary component on exit cost in hours and dollars

   Estimate the engineering hours to rebuild the component on an alternative stack, then multiply by a blended rate. Anything above roughly 40 hours goes on the client-facing risk register with a named owner.

3. 03

   Export transformation logic and orchestration definitions into the client's own repository

   SQL models, DAG definitions, and schema contracts should live in a repo the client controls, not only inside a vendor console. Confirm the export runs cleanly on a fresh environment before signing the handoff.

4. 04

   Document the credential and connection map with rotation ownership

   List every source system, the auth method, and who rotates each key. Handoff failures usually trace to a connector token that only one agency engineer knew about.

5. 05

   Run a parallel cutover window of at least two full refresh cycles

   Keep the outgoing and incoming pipelines running side by side until row counts and key metrics match across two scheduled runs. One clean run proves nothing about month-end volume.

6. 06

   Deliver a fallback path for any component with no open-source equivalent

   Where a proprietary automation layer has no substitute, write the manual or scripted workaround and the trigger conditions for using it. This is the clause that protects the retainer when a vendor changes pricing or sunsets a feature.

7. 07

   Get written client sign-off on the portability report before the final invoice

   Attach the component inventory, exit-cost scores, and fallback paths to the handoff document. Sign-off converts an informal transfer into a defensible delivery record.