The SQL-based data transformation framework orchestrating automated pipeline models from OLTP to Tier 3 OLAP.
data build tool (dbt) is the analytics engineering framework that enables data teams to transform, test, document, and version-control data models directly inside the warehouse. It compiles modular SQL SELECT statements into production tables and views, managing dependency DAGs and data quality tests.
Orchestrates the continuous refresh of the semantic layer, calculating freight order aggregates, carrier ratings, and carbon intensity indices.
Executes automated data reconciliation models, assertions, and freshness checks across PostgreSQL relational stores.
dbt performs data transformations (the T in ELT); it does not extract or transport data between external systems.