Glossary
Data ingestion
Moving data from its source systems into a storage or processing system where it can be transformed and analyzed.
Data ingestion is the process of bringing data from wherever it originates, an application database, a SaaS tool, a stream of sensor readings, into a system, typically a data lake or warehouse, where it can be stored, transformed and analyzed. It is the first stage of most data pipelines, before any transformation happens.
Ingestion can happen in batches, pulling a full or incremental extract on a schedule, or continuously via streaming and event pipelines, depending on how quickly the data is needed downstream. It is commonly built using pre-built connectors for common sources, or custom API integrations and webhooks for systems without one. Ingestion is distinct from the transformation step in ETL/ELT: ingestion is concerned with getting data in reliably, transformation with reshaping it once it has landed.
Ingestion matters because it is where data quality problems most often originate or first become visible, missing records, schema drift from a source system, duplicate loads from a retried job, and catching issues here is far cheaper than catching them after they've propagated through several downstream models. Common pitfalls include ingesting a full table on every run when an incremental approach would be far cheaper, and not handling schema changes in the source gracefully, which can silently drop or corrupt fields.
Last reviewed September 22, 2026