dbt
Data Transformation
Data build tool (dbt) enables analytics engineers to transform data in their warehouse by simply writing SQL select statements. Dbt handles turning these into tables and views.
Why We Use It
- SQL-Based: Write transformations in SQL, no complex coding needed
- Version Control: Git-based workflow for data transformations
- Testing: Built-in data quality testing framework
- Documentation: Auto-generated documentation from your code
- Modularity: Reusable macros and models
Use Cases
- Data warehouse transformations
- Data quality testing
- Analytics engineering workflows
- Documentation of data models