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: