Cloud · Azure

ADF vs Airflow

azureMediumazureadfairfloworchestrationetl

Interview question

How does Azure Data Factory (ADF) compare to Apache Airflow?

How to answer

The short answer

Azure Data Factory (ADF) is Azure's managed data integration / orchestration service. You build pipelines visually or via /ARM, with activities for copy, Databricks, Synapse, stored procedures, and more.

Apache Airflow is an open-source workflow orchestrator where pipelines are Python . On Azure you might run Airflow yourself, on AKS, or via managed options; many teams still compare ADF to Airflow conceptually.

Output
ADF:     UI / JSON pipelines --> managed cloud activities
Airflow: Python DAGs        --> operators/sensors you code

Comparison

DimensionADFAirflow
AuthoringLow-code + JSONPython-as-code
HostingFully managed AzureSelf-managed or managed Airflow
StrengthCopy data, Azure-native activitiesComplex logic, reusable Python, open ecosystem
TestingHarder unit-test storyDAGs/operators testable as code
PortabilityAzure-centricMulti-cloud / on-prem

When ADF wins

Heavy Azure stack, lots of copy/ into ADLS/Synapse, prefer GUI + managed ops.

When Airflow wins

Complex branching, custom Python, multi-cloud, or team already lives in DAG-as-code.

Interview tip: "ADF = managed Azure pipelines (often low-code); Airflow = Python DAG orchestration." Say both schedule/depend/retry; the difference is authoring model and lock-in.