Skip to main content

Glossary

What is batch processing?

Last updated Monday, Aug 3, 2026

Batch processing runs a job on a group of data at once, on a schedule or on demand, rather than processing each record the instant it arrives. A pipeline might read yesterday's orders every night at 2 AM, transform them, and load the results, instead of reacting to each new order in real time.

How it works

A batch is defined by a time window or a trigger: hourly, nightly, or on demand. The job runs on that schedule, usually managed by an orchestrator, and processes the whole dataset or a delta together. Results land all at once at the end of the run, not continuously as data arrives.

Why it matters

Batches are easier to reason about and retry: if a run fails, you rerun the whole batch, not a partial stream of events. That simplicity is a good fit whenever near-real-time freshness isn't the requirement, and it costs less to operate than a system that has to stay running around the clock.

How OptimaFlo runs batches

OptimaFlo's Data Engineer role builds pipelines as Airflow DAGs: template-based jobs that move data through Raw, Clean, and Ready on a schedule you set. That scheduled, whole-batch model is how the platform runs every pipeline today, from ingestion through Clean and Ready.

Related terms

  • Stream processing: The alternative model: processing each record as it arrives instead of in scheduled groups.
  • Data orchestration: The scheduler, Airflow in OptimaFlo's case, that triggers and sequences batch runs.
  • Change data capture: A technique for capturing only what changed, often paired with streaming rather than batch.

Frequently asked questions

No. Batch processing is about timing: running work in scheduled groups. ETL and ELT describe the order of extract, transform, and load. A pipeline can be batch and either ETL or ELT.

As often as the schedule allows, from every few minutes to once a day, set by whoever configures the pipeline's trigger.

No. OptimaFlo runs Raw, Clean, and Ready on the same scheduled Airflow batches today.

Browse every term or see the AI data team roles.

Staffed, not self-serve

See AI teammates work on your own data.

Now in early beta. One flat plan, no per-query tax. Runs in your cloud, and your tables stay in your account.