/dbt

dbt (data build tool) enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

Primary LanguagePythonApache License 2.0Apache-2.0

dbt logo

Code Climate CircleCI AppVeyor Slack

dbt (data build tool) enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

dbt is the T in ELT. Organize, cleanse, denormalize, filter, rename, and pre-aggregate the raw data in your warehouse so that it's ready for analysis.

dbt architecture

dbt can be used to aggregate pageviews into sessions, calculate ad spend ROI, or report on email campaign performance.

Understanding dbt

Analysts using dbt can transform their data by simply writing select statements, while dbt handles turning these statements into tables and views in a data warehouse.

These select statements, or "models", form a dbt project. Models frequently build on top of one another – dbt makes it easy to manage relationships between models, and visualize these relationships, as well as assure the quality of your transformations through testing.

dbt dag

Getting started

Find out more

Join thousands of analysts in the dbt community

Reporting bugs and contributing code

Code of Conduct

Everyone interacting in the dbt project's codebases, issue trackers, chat rooms, and mailing lists is expected to follow the PyPA Code of Conduct.