ETL vs ELT

Medium

big-data Snowflake Databricks

What is the main difference between ETL and ELT, and when is ELT preferred?

Multiple Choice

ETL loads data first then transforms; ELT transforms first then loads In ETL, data is transformed before loading; in ELT, raw data is loaded first and transformed in the target system, leveraging its compute power ETL is for batch processing; ELT is for stream processing They are identical processes with different names

Correct!

Incorrect — try again next time!

Upgrade to Pro to unlock solutions and explanations

ETL vs ELT

Multiple Choice

Related problems

Deep-dive guides