ELT (EN)

Concept

Extract, Load, Transform - modern approach to data integration

Definition

ELT is a modern approach to data integration where data is directly extracted from source systems and loaded unchanged into the target system. The transformation of the data only occurs after loading in the target system, typically in a data warehouse. This approach leverages the scalability of modern data warehouses and enables more flexible transformations.

Architecture

flowchart LR   A[Source Systems] --> B[Extraction]   B --> C[Loading]   C --> D[Data Warehouse]   D --> E[Transformation]   E --> F[Analysis & BI]

In Context

  • Typically used together with cloud-based data warehouses
  • Related to: ETL, data pipelines, Data Lake
  • Example use case: Enterprise-wide data analysis with tools like Snowflake, BigQuery or Redshift

In diesen Lernmodulen erwähnt

Quelle: AI Generated