Why it matters
Order protects the output.
A dashboard refresh must not start before validation and modelling finish.
Pipeline reliability
Airflow orchestration
Airflow controls when tasks run, which task depends on another task, and what happens after failure.
Visual model
A workflow is more than a schedule.
The dependency graph prevents a downstream task from using incomplete upstream data.
Validate source
→
Load MySQL
→
Run dbt and tests
Record status
←
Refresh reporting
←
Publish marts
Failure handling
Stop at the failed task.
The workflow records the failure and keeps downstream tasks from publishing incomplete data.
Safe recovery
Rerun the controlled path.
Idempotent loads support recovery without duplicate data.
Used in