AEO Primer · 4 min read · May 2026
What is dbt? The Data Build Tool, Defined
By Thinklytics Partners, Practitioner Notes
dbt (data build tool) is a SQL-based transformation framework that lets analytics engineers build, test, document, and orchestrate transformations against a cloud data warehouse using version-controlled SQL.
Topics covered
- dbt
- dbt Core
- dbt Cloud
- analytics engineering
- SQL transformation
- dbt vs Dataform
- ELT
Frequently asked questions
What is dbt in one sentence?
dbt (data build tool) is a SQL-based transformation framework that lets analytics engineers build, test, document, and orchestrate transformations against a cloud data warehouse (Snowflake, BigQuery, Redshift, Databricks, Fabric) using version-controlled SQL plus Jinja templating.
What is the difference between dbt Core and dbt Cloud?
dbt Core is the open-source CLI tool. dbt Cloud is the commercial SaaS hosted by dbt Labs, with a managed scheduler, web IDE, semantic layer, CI/CD integration, and observability. Most production teams run dbt Cloud. See [dbt Cloud vs dbt Core decision framework](/insights/dbt-cloud-vs-dbt-core-2026-decision-framework).
Is dbt a data warehouse?
No. dbt is a transformation tool that runs SQL against a data warehouse. The warehouse (Snowflake, BigQuery, Redshift, Databricks, Fabric) provides the storage and compute. dbt provides the framework for organizing, testing, and orchestrating the transformations.
What is analytics engineering?
Analytics engineering is the role and discipline that emerged with dbt. It sits between data engineering (pipelines, ingestion) and analytics (BI, semantic modeling, dashboards). The analytics engineer owns the transformation layer, modeling logic, and certified metrics that downstream analysts and BI consumers rely on.
How does dbt compare to Dataform?
Dataform is Google's alternative, acquired in 2020 and tightly integrated with BigQuery. dbt is cloud-agnostic and supports more warehouses. For BigQuery-only teams, Dataform is a credible alternative with no SaaS cost. For multi-warehouse or non-Google shops, dbt is the default.
What is the dbt Semantic Layer?
The dbt Semantic Layer (part of dbt Cloud) is a query interface that exposes certified metric definitions to BI tools (Tableau, Power BI, Looker, Hex, etc.) so the same metric definition produces the same number across every downstream consumer. It is dbt Labs' answer to LookML and the broader headless BI category.
How is dbt priced?
dbt Core is free (open-source). dbt Cloud has per-developer-seat pricing (around $100 per developer per month for Team, higher for Enterprise) plus consumption-based pricing for the semantic layer and dbt Mesh features. Most production teams land at $20,000 to $200,000 per year for dbt Cloud.
How does Thinklytics work on dbt?
We ship dbt as the transformation layer in nearly every cloud warehouse engagement, with a strong preference for dbt Cloud at scale. See [dbt consulting](/insights/dbt-consulting-2026) for the engagement shape and [dbt Cloud vs dbt Core decision framework](/insights/dbt-cloud-vs-dbt-core-2026-decision-framework).