ELT is a variant of ETL. Whereas ETL stands for extract, transform, and load, ELT reverses the last two steps: it stands for extract, load, and transform.

In ELT, data is loaded unchanged into the analytics system, such as a data warehouse, data lake, or data lakehouse. Transformations are only performed within the analytics system. In this way, the analytics system has a copy of raw data and of the data from each step in different transformation processes. With ELT, the analytics system can respond flexibly to new or changing requirements. ELT is becoming more cost-effective as lower-cost compute becomes available, especially in certain data lakehouses. 

Related terms: ETL

On the Onehouse website: 

Be the first to hear about news and product updates

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We are hiring diverse, world-class talent — join us in building the future.