What is the difference between ETL and ELT?
spaceto flip
ETL: Extract, Transform, Load. Transform happens before loading -- you clean and reshape data, then put it in the destination. ELT: Extract, Load, Transform. Load raw data first, then transform inside the destination (e.g., dbt models in Redshift). ELT is gaining popularity because cloud warehouses have cheap compute. ETL is better when you want to filter/reduce data before paying for warehouse storage.