Airflow ExternalTaskSensor waits forever: logical date mismatch, execution_delta and failed upstream states
An ExternalTaskSensor pokes for hours while the upstream DAG finished long ago. Compare logical dates, fix execution_delta, set failed_states and timeouts, and know when to switch to assets.