what does ELT stand for? Extract, Load, Transform.
ETL is like cooking before serving. ELT is serving ingredients and letting the diner (your warehouse) cook.
ELT’s faster and cheaper now. Tools like Fivetran handle the extract/load, then dbt does the transform. Magic!
---
Wow, thanks everyone! This makes so much more sense now. I didn’t realize how much cloud warehouses changed the game—ELT sounds way more flexible than ETL.
Gonna play around with dbt + BigQuery this weekend. Quick follow-up: any gotchas or best practices for someone new to ELT? Or is it as straightforward as it seems?
(Also, Fivetran looks dope—def checking that out.)
ETL is like cooking before serving. ELT is serving ingredients and letting the diner (your warehouse) cook.
ELT’s faster and cheaper now. Tools like Fivetran handle the extract/load, then dbt does the transform. Magic!
---
Wow, thanks everyone! This makes so much more sense now. I didn’t realize how much cloud warehouses changed the game—ELT sounds way more flexible than ETL.
Gonna play around with dbt + BigQuery this weekend. Quick follow-up: any gotchas or best practices for someone new to ELT? Or is it as straightforward as it seems?
(Also, Fivetran looks dope—def checking that out.)