Orchestration Lock-In Surface

The Orchestration Lock-In Surface is the layer of a data stack where switching costs concentrate: the scheduler, DAG definitions, and asset graph that encode how every pipeline runs. Ingestion connectors and transformation SQL are largely portable, but orchestration logic is where agency delivery time gets trapped. A managed Airflow platform such as Astronomer, an asset-centric scheduler like Dagster, or a metadata-driven orchestrator like Coalesce each impose different migration costs, and the choice compounds across every client retainer. For agencies, this matters because a pipeline rebuilt in three weeks is billable, while a pipeline rebuilt in three months destroys the margin on a fixed-fee engagement. The practical test: before committing a client to any orchestrator, estimate the hours required to re-express every DAG elsewhere. If that number exceeds the original build estimate, the orchestration layer is the lock-in surface, not the warehouse or the connectors.