Data Build Tool (dbt) #
Back in my day, the common design was “ETL” – extract, transform, load.
Nowadays, with the widespread adoption of cloud computing and the dramatic drop in data storage costs, the current paradigm is all about “ELT” – extract, load, transform. Bit of a flip.
That last T bit is where dbt really shines – it makes the transformation phase as simple as a SQL query.