It provides built-in data_interval_start and data_interval_end variables, making it easy to write idempotent queries like SELECT * FROM sales WHERE date >= {{ data_interval_start }} .
How does this look in practice? Modern orchestrators like Apache Airflow have adopted this philosophy heavily. crondataintervaltimetable
Its ability to "know" which past intervals are missing is its greatest strength. the data interval is.
The critical innovation is and backfilling . If the data interval misses a scheduled run (e.g., server downtime), the timetable must recognize the gap and execute a catch-up run. The cron trigger is no longer the master; the data interval is. crondataintervaltimetable