Home/Insights/Data Engineering

What is DBT and why so many companies use it?

By Ani BjörkströmPublished 19 July 2026Reviewed 17 November 20266 min video + articleData Engineering

What is DBT and why so many companies use it?
▶ Watch the full 6-minute video · with chapters & transcript

DATA ENGINEERING

What is dbt, and why do so many companies use it?

In short: dbt (data build tool) transforms data already in your warehouse using plain SQL, adding version control, testing, and documentation — if you know SQL, you already know 90% of dbt.

Key takeaways

  • dbt (data build tool) transforms data already in your warehouse using plain SQL, adding version control, testing, and documentation — if you know SQL, you already know 90% of dbt.
  • dbt is only the T in the pipeline: it writes SELECT-based models and manages dependencies, while the warehouse — Snowflake, BigQuery, or Fabric — does the processing.
  • Without dbt, your real test suite is stakeholders noticing broken numbers; with dbt, tests live in a schema YAML file and run with one dbt test command.

dbt sits between the raw data in your warehouse and the reports your stakeholders see. Ani Björkström, a tech consultant based in Stockholm, explains where dbt fits in the pipeline, what life without it looks like, and when to skip it.

Where does dbt fit in the data pipeline?

dbt sits between the warehouse, where source data lands raw and messy, and the presentation layer — Hex, Streamlit, or Power BI reports. Upstream, sources like CRM databases feed extract-and-load tools, which save data into a warehouse such as Snowflake, BigQuery, or Fabric.

dbt itself does not process your data. It is the brain: you write models, which are just SELECT queries in SQL, and the warehouse runs them — in Snowflake, your Snowflake warehouses execute the dbt models.

How does dbt know which tables to build first?

Through the ref function, which names the source each model reads from, dbt builds a dependency graph and knows which models depend on which. When you run dbt run, it respects that order — staging models like stage_orders and stage_customers first, then the enriched data mart, then downstream contracts like daily_revenue.

The graph also protects the team, not just the run order. Everyone can see that daily_revenue reads from orders, so a staging change immediately signals which downstream tables may need updating.

What is life without dbt actually like?

Without dbt, transformations live in stored procedures and SQL files on a shared drive, run by scheduled jobs. The setup works — until a new joiner cannot learn the execution order, and there is no version control, testing, or documentation.

This is not because data people are sloppy; SQL alone has no framework for dependencies, tests, or docs. dbt fixes each gap: models live in Git, tests like "order_id must be unique and not null" sit in a schema YAML file and run with dbt test, and dbt docs generates a searchable site covering every table, column, and linkage from raw sources to dashboards.

When should you use dbt — and when should you skip it?

Use dbt when transformations are SQL in a cloud warehouse, more than two people work on the project, broken data has a real cost, and you have outgrown a handful of queries. Skip it in the cases below.

Use dbt whenSkip dbt when
Transformations are SQL in a cloud warehouseYou are still choosing an extract-and-load tool — dbt only transforms data already loaded
More than two people work on the projectYou are the only person on the team
Broken data has a real costYour work is mainly Python and machine learning
You have outgrown a handful of queriesYou are not comfortable with Jinja or framework conventions

FAQ

Does dbt replace my data warehouse?

No. dbt writes and orders SQL models, but the warehouse does all the compute when the models run.

Do I need to learn a new language for dbt?

No. dbt models are SELECT queries in plain SQL, so knowing SQL covers 90% of dbt; the rest is conventions like the ref function and schema YAML files.

How does testing work in dbt?

You declare expectations in a schema YAML file and a single dbt test command runs all of them, instead of waiting for a stakeholder to report a broken dashboard.

Want this working inside your finance team?

Ani Björkström

Ani Björkström — founder of QvantX Sweden AB, a Stockholm consultancy building AI solutions for banks, asset managers and finance teams. Anthropic partner. Every article starts from a real client build, minus the confidential parts. LinkedIn →