dbt Explained

dbt (data build tool) is a SQL-based transformation and modeling tool developed by dbt Labs that automates the data transformation process. It allows data professionals to iteratively build data models, create relationships and dependencies between them, and materialize those models as tables and views in a data warehouse. The YAML files are used for project configuration, curating a data dictionary, and applying data integrity tests. dbt is not an ETL tool but works with Fivetran to provide end-to-end ELT processes. It integrates directly into Fivetran, allowing users to orchestrate cleaning, testing, transformation, modeling, and documentation of data sets.