Glossary Data movement

ETL and ELT

Extract, transform, load. In ETL the transform runs before the load; in ELT the raw data is loaded first and the warehouse transforms it.

In plain terms

What it means.

ETL and ELT — Extract, transform, load. In ETL the transform runs before the load; in ELT the raw data is loaded first and the warehouse transforms it.

Both patterns run on the same Lima engine. A mixed pattern does a light clean in Lima and the heavy work in the warehouse. The choice depends on where the compute is cheapest and where the checks need to run.

See also

Related terms and pages.

Related terms

Where it is used

/platform/backbone/pipelines

Back to the glossary.

Sixty-nine terms in five groups.