Data ingestion
What Is Data Ingestion?
Data ingestion is the process of collecting data from its sources and moving it into a system where it can be stored, processed, or analyzed. It is the entry point of a data pipeline, responsible for connecting to heterogeneous producers such as operational databases, application logs, message queues, sensors, and third-party interfaces, and for delivering their output to a destination such as a data warehouse, data lake, or stream processor. Ingestion is distinct from transformation: its job is reliable acquisition and delivery, with any reshaping of the data handled before or after, depending on the pipeline design.
The activity is defined explicitly in reference architectures. The NIST Big Data Reference Architecture places collection as the first stage of the information value chain, notes that data is usually collected for a specific known purpose, and observes that the same data is frequently reused later for purposes nobody anticipated at collection time. That reuse expectation is why ingestion designs favor retaining raw fidelity rather than discarding fields that look unnecessary.
Batch and Streaming Modes
Ingestion runs in one of two modes, and most production systems use both. Batch ingestion moves data at fixed intervals or on a trigger, loading files, database extracts, or query results in bounded chunks. It is simple to reason about, tolerates source downtime, and suits nightly reporting or regulatory reporting cycles. Streaming ingestion instead moves records continuously as they are produced, typically through a durable log such as Apache Kafka or Apache Pulsar, and delivers latency measured in seconds or less.
A framework for data stream ingestion sets out the components this mode requires: publish-subscribe transport, buffering that absorbs producer bursts without back-pressuring the source, schema handling, and connectors that isolate the pipeline from source-specific protocols. The tradeoff is operational. Streaming systems must handle partial failure, replay, and duplicate delivery continuously, whereas a failed batch job can simply be rerun.
Extraction Patterns and Source Connectivity
How data leaves the source shapes the whole pipeline. Full extraction copies an entire table or file each cycle and is easy but expensive. Incremental extraction uses a watermark column such as a modification timestamp, which is cheaper but misses deletions. Log-based change data capture reads the database transaction log directly and emits an ordered stream of inserts, updates, and deletes, which captures deletions and imposes almost no query load on the source.
The placement of transformation separates the two dominant architectures. A survey of pipeline tools for data engineering contrasts extract-transform-load pipelines, which reshape data in flight before loading, with extract-load-transform pipelines, which land raw data in the destination and transform it there using the destination's compute. The second pattern has become common with cloud warehouses because storage is cheap and raw data can be reprocessed when requirements change.
Reliability and Quality Controls
Ingestion is where most pipeline defects originate, so delivery guarantees and validation belong here. Systems specify at-most-once, at-least-once, or exactly-once semantics, the last usually achieved through idempotent writes or transactional offsets rather than true single delivery. Schema evolution needs explicit handling, since a producer adding or renaming a field can silently corrupt downstream tables. Research on data pipeline quality and the root causes of pipeline defects identifies schema changes, missing values, and unvalidated source data as recurring failure sources, and argues for filtering erroneous items at the ingestion boundary rather than repairing them later.
Applications
Data ingestion underpins systems in a range of fields, including:
- Enterprise analytics and business intelligence warehousing
- Industrial IoT and predictive maintenance, which collect high-rate sensor telemetry
- Security operations, where log collection feeds detection and incident response
- Financial market data capture and trade surveillance
- Clinical and genomic research repositories that consolidate multi-site data
- Machine learning feature stores and model training pipelines