⚙️dbt (Data Build Tool)
Also known as dbt, Data Build Tool, dbt Core, dbt Cloud
A tool that runs your SQL files. Each one builds a table, in the right order.
Think of it like
It is like a recipe book for your data. Each recipe says what to use, and the book cooks them in the right order.
Why it matters
It brings code habits to SQL: version control, tests, reviews and docs. That made it the usual tool for the T in ELT.
Definition
Example code
console
$ dbt run --select daily_sales
1 of 1 OK created sql table model analytics.daily_salesCommon mistake
Key takeaways
- 1A SELECT per file. Each one builds a table or view.
- 2ref() sets the order. dbt builds the graph.
- 3Tests and docs. Kept beside the code.