ETL vs. ELT

Difficulty: Intermediate

Question

Extract-Transform-Load (ETL) vs Extract-Load-Transform (ELT).

Answer

ETL transforms data before loading it into the target. ELT (modern) loads raw data first and uses the power of the target system (like Snowflake/Redshift) to transform it.

Concepts covered

Data Pipeline, Data Lake, Data Warehouse