ETL vs ELT

Medium

big-data Snowflake Databricks

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