Loading content
ELT is an approach to data integration that allows for efficient processing of large volumes of data. After loading the data into a target system, the transformation occurs, providing flexibility in analysis and reporting.
Use this profile to understand the building block briefly, place it in the model, and switch to the 360° assessment when needed.
Theoretical construct: explains a term, principle, or mental model.
What you need to understand to reason about a domain.
ELT is a data integration method: data is extracted from sources, loaded into a target system, and transformed there afterward.
ELT emerged as classic ETL pipelines gave way to cloud-ready data integration. As storage, compute, and network bandwidth became cheaper, it became practical to load data into the target system first and clean, model, and enrich it there. That keeps ingestion and loading stable while transformation can adapt more easily to new analytical questions.
ELT works like a two-stage lab: raw data is first moved into a central landing and storage area. There it remains broadly usable until an analysis need appears. Transformation steps then shape the data into metrics, tables, or models for reporting, exploration, or downstream processing. The key idea is to separate data intake from business shaping.
After loading, structures are shaped so they support business analysis and reporting.
Applications, databases, or platforms provide the raw data for the pipeline.
A warehouse, lakehouse, or similar platform receives the data first.
Data is cleaned, standardized, enriched, or turned into an analyzable model.
Data intake remains stable even when analytical questions or models change.
ELT is useful when many sources must be combined, analytical requirements change often, or the target platform can store raw data economically. It supports flexible modeling and later business logic, but it also requires governance, quality checks, and control over storage and processing costs. If data must be heavily reduced before it can be stored, a classic ETL pattern is often the better fit.
Where this building block is located in the topic model.
Explore how this building block connects to concepts, methods, technologies, and tools.
These sources establish the term and its professional meaning.
All direct connections of the current building block in a compact text view.
This classification shows where the building block typically matters, how demanding it is, and what kind of impact it has in the model.
The level within the organization (enterprise, domain, team) at which the AssetBlock is applied.