100% Free Forever
AI-Powered Learning
Industry Expert Content
Certificates & Badges
Learn At Your Own Pace
Programming

Backfilling and Catchup

Understanding Airflow's catchup behavior and the airflow dags backfill command for (re)processing historical data intervals.

Scheduling & ExecutionIntermediate8 min readJul 10, 2026
Analogies

The catchup Parameter

When a DAG is first unpaused, Airflow's default behavior, catchup=True, is to create a DagRun for every data interval between the DAG's start_date and now, running them all as fast as the scheduler and executor can process them; setting catchup=False on the DAG (or the CATCHUP_BY_DEFAULT config globally) makes the scheduler only create a DagRun for the most recent completed interval going forward, which is almost always what you want for dashboards or alerting DAGs where historical backfill has no value.

🏏

Cricket analogy: Like a broadcaster who, upon regaining a lost satellite feed, chooses to replay every missed over from the start of the innings rather than just resuming live, catchup=True makes Airflow create a DagRun for every missed interval since start_date.

Manual Backfills with the CLI

The airflow dags backfill command lets you explicitly (re)run a DAG over a specified date range regardless of the catchup setting, which is the standard tool for reprocessing historical data after fixing a bug in a transformation, backfilling a brand-new DAG against months of historical source data, or regenerating a report after an upstream schema change; you can pass --reset-dagruns to clear and rerun existing DagRuns in that range, and -t to limit the backfill to specific tasks by regex rather than the whole DAG.

🏏

Cricket analogy: Like a broadcaster deliberately re-airing an entire historical Ashes series with corrected graphics after finding a scorecard error in the original footage, airflow dags backfill lets you deliberately rerun a DAG over a chosen historical date range to fix past output.

execution_date, Data Intervals, and Idempotency

Backfilling only works correctly if your tasks are idempotent and parameterized on the run's data interval, in Airflow 2.2+ accessed via {{ data_interval_start }} and {{ data_interval_end }} in Jinja templates, rather than on wall-clock time; a task that queries 'yesterday' using datetime.now() instead of the templated interval will produce identical, wrong output no matter which historical interval a backfill run is actually processing, since it ignores the execution context entirely.

🏏

Cricket analogy: Like a stats system that must calculate a player's figures for a specific historical match using that match's actual date rather than today's date, a backfilled task must use the templated data_interval_start rather than datetime.now(), or every replayed match returns identical, wrong figures.

bash
# Backfill a DAG for a specific historical window, resetting any existing DagRuns
airflow dags backfill \
  --start-date 2026-01-01 \
  --end-date 2026-01-31 \
  --reset-dagruns \
  -t "transform_.*" \
  orders_hourly_rollup

In Airflow 2.2+, prefer {{ data_interval_start }} and {{ data_interval_end }} over the deprecated {{ execution_date }} macro; for most schedules they represent the same window, but data_interval_* is explicit about representing the start and end of the processed interval rather than a single ambiguous timestamp.

Running airflow dags backfill against a DAG with max_active_runs set low can silently serialize what you expected to be a fast parallel replay; check max_active_runs and executor capacity before backfilling a large historical range, or the job can take far longer than anticipated.

  • catchup=True (the default) creates a DagRun for every missed interval since start_date when a DAG is unpaused.
  • catchup=False only schedules the most recent completed interval going forward, ideal for dashboards and alerting DAGs.
  • airflow dags backfill explicitly (re)runs a DAG over a chosen historical date range regardless of catchup.
  • --reset-dagruns clears and reruns existing DagRuns in the target range; -t limits the backfill to specific tasks by regex.
  • Backfilling requires idempotent tasks parameterized on data_interval_start/data_interval_end, not wall-clock time.
  • Tasks that hardcode datetime.now() instead of using the templated interval produce identical, wrong output for every backfilled run.
  • max_active_runs and executor capacity determine how much a backfill can actually parallelize.

Practice what you learned

Was this page helpful?

Topics covered

#Programming#ApacheAirflowStudyNotes#BackfillingAndCatchup#Backfilling#Catchup#Parameter#Manual#StudyNotes#SkillVeris#ExamPrep

Frequently Asked Questions

21 categories · pick one to explore

Where can I get free study notes for programming and tech subjects?
SkillVeris offers completely free study notes covering programming and tech subjects, with no signup fees or paywalls. The notes are structured by course and topic, written for quick understanding, and enriched with the Learn Through Hobbies analogy method, so you can revise concepts through cricket, music, gaming, cooking and more.
Are SkillVeris study notes good for exam revision?
Yes, the study notes are designed for efficient revision: each topic answers its heading immediately, keeps explanations concise, and links to related glossary terms and cheat sheets. Students preparing for university exams or certification tests use them as quick revision notes because they distil concepts without the padding of full textbooks.
What subjects do the free study notes cover?
The study notes span the platform's main domains, including AI and machine learning, Python and programming, web development, DevOps, cloud, security and databases. Coverage mirrors the 37 live courses, so notes exist for the topics you are actually studying, and new note sets are added as courses launch.
How are SkillVeris study notes different from regular textbooks?
The notes are answer-first, concise and free, whereas textbooks are long and often expensive. Each section explains one concept directly, then reinforces it through selectable hobby analogies like cricket or cooking. Notes also cross-link to the glossary, blog and cheat sheets, letting you jump to related material instantly instead of flipping pages.
Can I use the developer study material without creating an account?
The study notes are free to access, and SkillVeris does not charge anything for its developer study material at any point. Browsing notes is straightforward from the Study Notes section, and if you want progress tracking, certificates and AI Mentor conversations tied to your learning, a free account unlocks those extras.
Do the study notes explain concepts with analogies?
Yes, this is a signature SkillVeris feature. Study notes use the Learn Through Hobbies method, explaining technical concepts through analogies from twelve domains including cricket, music, gaming, photography, travel, movies, fitness, chess, cooking, finance, business and sports. You can switch the analogy domain instantly to whichever hobby makes the concept click.
Are the revision notes suitable for last-minute exam preparation?
Yes, revision notes on SkillVeris work well for last-minute preparation because every section states the answer in its first sentences, so skimming is genuinely effective. Pair them with the relevant cheat sheet for formulas and syntax, and use the glossary for any unfamiliar term you meet while cramming.
Is there free study material for AI and machine learning?
Yes, SkillVeris provides free study notes across its AI and ML catalogue, covering Python for AI, deep learning frameworks like PyTorch and TensorFlow, Hugging Face Transformers, Large Language Models, RAG, AI agents and MLOps. All of it is free, making it a strong resource for Indian students and global learners alike.
Can beginners understand the study notes, or are they for experts?
Beginners can absolutely use them. The notes are written in plain language, define terms as they appear, and lean on hobby analogies to make abstract ideas concrete. Difficulty scales with the underlying course level, so beginner-course notes stay gentle while advanced-course notes go deeper, and the glossary supports you throughout.
How do study notes connect with SkillVeris courses?
Study notes are organised by course and topic, so they map directly to the structured courses and their 24–40-lesson curriculum. Many learners study a lesson first, then use the matching notes for revision before module assessments and the final exam, where 80 percent is required to pass and earn the certificate.
Are there study notes for Python specifically?
Yes, Python is well covered through notes tied to the Python-focused courses, including Python for AI and ML. Topics span fundamentals through applied machine learning usage. You can reinforce the notes with Python practice in Code Lab, which runs code in your browser with no installation required.
Do the study notes include code examples?
Yes, study notes include code examples wherever a concept is best shown in code, alongside explanations, key points and analogies. Reading a snippet in the notes and then reproducing it yourself in Code Lab is an effective loop, since Code Lab lets you run code in the browser across six languages.
How often is new study material added to SkillVeris?
Study material grows alongside the course catalogue. Whenever new courses join the platform's 37 live courses, matching study notes, glossary entries and cheat sheets are added so the resources stay in sync. Existing notes are also refined over time, so it is worth revisiting topics you studied earlier.
Can I use SkillVeris notes to prepare for technical interviews?
Yes, the notes make excellent interview revision because they compress each concept into direct, answer-first explanations, which mirrors how you should answer interview questions. Combine them with the SkillVeris interview questions feature, which includes readiness scoring, to test whether your revision has actually made you interview-ready.
Are the study notes mobile-friendly for studying on the go?
Yes, the study notes are built to load fast and read comfortably on mobile devices, so you can revise during a commute or between classes. Sections are short and answer-first, which suits small screens, and analogy switching works on mobile too, letting you study anywhere without carrying books.
What is the difference between study notes and cheat sheets?
Study notes explain concepts in depth with context, examples and analogies, making them ideal for learning and revision. Cheat sheets are compact quick-reference summaries of syntax, commands and key facts, ideal once you already understand a topic. Most learners study the notes first, then keep the cheat sheet handy while coding.
Do study notes help if I am stuck on a course lesson?
Yes, reading the matching study notes often clarifies a lesson because the same concept is explained from a different angle, frequently with a different analogy. If you are still stuck, ask the AI Mentor, which answers 24/7 at Quick, Detailed or Deep-dive depth until the idea genuinely makes sense.
Is there free study material for DevOps and cloud topics?
Yes, SkillVeris carries free study notes for DevOps and cloud topics as part of its coverage across 37 live courses. The material suits learners following the DevOps Engineer or Cloud Engineer paths, and it links to related glossary terms and cheat sheets so you can revise the whole toolchain in one place.
Can school or college students in India use these notes for projects?
Yes, students across India and worldwide use SkillVeris notes for coursework, projects and exam preparation, and everything is free, which matters for student budgets. The notes explain concepts clearly enough to cite in project reports, and Code Lab lets you prototype the project code directly in your browser.
How should I combine study notes with other SkillVeris resources?
A proven loop: learn from a course lesson, revise with the matching study notes, look up unfamiliar terms in the glossary, keep the cheat sheet open while practising in Code Lab, and quiz yourself with interview questions. The AI Mentor fills any remaining gaps 24/7, at whatever depth you need.

What Learners Say

Real journeys from the SkillVeris community — swipe for more.

SkillVeris taught me Python through Cricket. Now I’m building real projects and feeling confident!
Arjun S. · B.Tech Student
The best platform for hobby-based learning. Concepts finally stick.
Priya R. · Data Analyst
I went from zero coding to a portfolio of projects — all by learning through my love for gaming. Landed my first internship!
Kabir M. · CS Undergraduate
Trending Topics50 popular tags — tap to explore
Trending CoursesAll 37 free courses — tap to browse