dbt (data build tool) is an open-source command-line tool that enables analytics engineers to transform data inside their data warehouses by writing SQL SELECT statements. dbt handles the boilerplate of materializing those SELECT statements as tables and views, managing dependencies between models, running tests, generating documentation, and building a dependency-aware execution graph. By applying software engineering practices – version control, testing, documentation, modularity, and CI/CD – to the analytics workflow, dbt has defined the discipline of “analytics engineering.”

dbt operates on the ELT (Extract, Load, Transform) paradigm: data is first loaded into a warehouse by extraction tools (Fivetran, Airbyte, Stitch; Fivetran now owns dbt Labs, see below), and then dbt handles the “T” (Transform) inside the warehouse using the warehouse’s own compute. Models are SQL files that define transformations as SELECT statements, with Jinja templating for dynamic SQL generation, macros for reusable logic, and ref() functions for dependency management. dbt automatically infers the DAG of model dependencies and executes them in the correct order. Built-in testing validates data assumptions (uniqueness, not-null, referential integrity, accepted values), and dbt generates a browsable documentation site with lineage graphs.

dbt supports all major analytical databases including Snowflake, BigQuery, Redshift, Databricks, PostgreSQL, DuckDB, and many others via community-maintained adapters. It has become an essential tool in the modern data stack, used by thousands of companies from startups to enterprises including JetBlue, Hubspot, and GitLab.

Key Capabilities

  • SQL-Based Transformations - Define data models as SELECT statements with Jinja templating, macros, and automatic dependency resolution
  • Data Testing - Built-in and custom tests for schema validation, data quality assertions, and referential integrity checks
  • Documentation and Lineage - Auto-generated documentation site with column descriptions, model descriptions, and interactive DAG lineage visualization
  • Multi-Warehouse Support - Adapters for Snowflake, BigQuery, Redshift, Databricks, PostgreSQL, DuckDB, and 30+ other databases

Cloud Equivalents

dbt is the open-source alternative to the transformation capabilities in AWS Glue, Azure Data Factory Mapping Data Flows, and Google Cloud Dataform (which Google acquired and integrated with BigQuery). Unlike visual ETL tools, dbt embraces SQL and software engineering practices, making transformations testable, version-controlled, and reviewable.

Origins and History

dbt was created by Tristan Handy and Drew Banin at RJMetrics in 2016. After RJMetrics was acquired, they founded Fishtown Analytics (later renamed dbt Labs) to develop dbt full-time. dbt Core is licensed under the Apache License 2.0. dbt Labs offers a managed service (long known as dbt Cloud; plans run from a free single-seat Developer plan to paid Starter and Enterprise tiers) for development, orchestration, CI/CD, and collaboration, built increasingly on the newer dbt Fusion engine. Before its merger, dbt Labs raised over $400 million in venture funding, reaching a $4.2 billion valuation.

Merger with Fivetran. Fivetran and dbt Labs announced an all-stock merger on 13 October 2025 and completed it on 1 June 2026. The combined company initially operates as “Fivetran + dbt Labs”, with Fivetran co-founder George Fraser as CEO and dbt co-founder Tristan Handy as President. At completion the company released dbt Core v2.0 (alpha), which open-sources the Fusion engine runtime under Apache 2.0. dbt says its community has over 100,000 active members.

Sources

  1. https://www.getdbt.com/
  2. https://github.com/dbt-labs/dbt-core
  3. dbt Labs. “Fivetran + dbt Labs Complete Merger to Create the Data Infrastructure for Trusted AI Agents.” 1 June 2026. https://www.getdbt.com/blog/fivetran-dbt-labs-complete-merger-to-create-the-data-infrastructure-for-trusted-ai-agents
  4. dbt Labs. Pricing (Developer, Starter, Enterprise plans), checked 26 September 2026. https://www.getdbt.com/pricing