Back to glossary

ELT

A data integration process where data is extracted and loaded into the target system, and then transformed within the target system.

AbbreviationELT
Categoryai

Overview

ELT (Extract, Load, Transform) is an alternative to ETL. In ELT, data is extracted from source systems and loaded into a target system (like a cloud data warehouse) in its raw form. The transformation then happens using the processing power of the target system.

Advantages

  • Speed: Faster loading of raw data.
  • Scalability: Leverages the power of modern cloud warehouses.
  • Flexibility: Raw data is available for different types of transformations later.

Popular Tools

  • dbt (data build tool)
  • Snowflake
  • BigQuery

Related Terms

ETLData IntegrationData EngineeringData Lakehouse