Airflow & DAGs · Advanced Development

logical_date vs actual runtime

Hardlogical-dateschedulingdata-interval

Interview question

What is the difference between logical_date and actual runtime?

How to answer

The short answer

logical_date is the data interval / scheduled period for a run. It is not necessarily the clock time when the task started.

A daily DAG for "data for January 1" may actually execute after that interval ends (for example on January 2).

Get this wrong and paths and incremental loads go sideways.