dbt (EN)

Definition

dbt (Data Build Tool) is an open-source development environment specifically designed for transforming data in SQL. With dbt, you can define data models as SQL files that are automatically converted into complete data pipelines. The tool enables the definition of tests to ensure data quality and supports the documentation of your data models. dbt can be seamlessly integrated with orchestration tools like Apache Airflow.

Architecture

flowchart LR   A[Source data] --> B[dbt Core]   B --> C[Transformations]   C --> D[Tests]   D --> E[Documentation]   E --> F[Target data model]   F --> G[BI tools/Analysis] 

In Context

• Typically used together with data warehouses such as Snowflake, BigQuery or Redshift
• Related to: ELT processes, data modeling, data quality assurance
• Example use case: Transformation of raw data from a data lake into analysis-ready models for Business Intelligence