🧭Extract, Load, Transform (ELT)
Also known as ELT
Load the raw data first. Then clean it in the warehouse.
Think of it like
It is like putting all the food in the fridge first. You wash each thing when you need it.
Example
A startup loads raw app events into BigQuery each hour. Then analysts write SQL. It turns them into a count of users per day.
Why it matters
The raw data is kept. So when you fix a bug, you do not need to go back to the source.
Definition
Example code
sql
CREATE TABLE clean_orders AS
SELECT id, LOWER(email) AS email, total
FROM raw_orders
WHERE total > 0;Common mistake
Key takeaways
- 1Load first. Raw data lands just as it is.
- 2Transform in place. SQL runs inside the warehouse.
- 3Raw copy kept. You can rebuild any table later.