ETL vs ELT

Concepts: paEltVsEtl

What They Want to Hear 'ELT for batch. Load raw data into the warehouse first, then transform it there using dbt. This preserves the raw data for re-transformation if business logic changes, and modern warehouses have the compute to handle it.' That is the safe, confident answer. ETL is the older pattern where you clean data before loading. The difference is just the order: clean-then-load (ETL) vs load-then-clean (ELT).