AI engineering glossary · Data engineering

What is dbt?

dbt (also called data build tool): An open-source tool that lets teams build warehouse transformations as SQL select statements, adding version control, tests, documentation and dependency ordering. It performs the transformation stage of ELT inside the warehouse.

Level: intermediateTopic: Data engineering

dbt: an example

A dbt model called orders_clean selects from raw_orders, and a test checks that order_id is unique and not null.

Related terms

More Data engineering terms

Where you learn it

dbt is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.

Before you go

Take the cheat sheet with you

One free PDF: the key AI-engineering terms, formulas and Python idioms. No spam; unsubscribe any time.