Data Archives - Software Engineering Daily DBT: Data Build Tool with Tristan Handy
13 snips
Sep 28, 2021 AI Snips
Chapters
Transcript
Episode notes
DBT Brings Rails‑Like Abstraction To SQL
- DBT runs SQL against modern cloud warehouses and provides higher-level programming abstractions.
- Tristan compares DBT to Rails: it reduces SQL code size dramatically and enables non-engineers to build production pipelines.
Start DBT By Learning Ref And Config
- Learn two DBT functions to get started: ref to reference models and config to control materialization.
- With those plus SQL you can become productive immediately and then extend with macros and custom materializations.
Declarative Idempotence Makes Pipelines Reproducible
- DBT's core is declarative and idempotent, inspired by Terraform, making warehouse state reproducible.
- You can destroy a schema and re-run dbt to reach the exact state your code describes, reducing fragile stored‑procedure complexity.
