What is dbt?
dbt™ is a SQL-first transformation workflow that lets teams quickly and collaboratively deploy analytics code following software engineering best practices like modularity, portability, CI/CD, and documentation. Now anyone on the data team can safely contribute to production-grade data pipelines.
How dbt works
Version Control and CI/CD
Deploy safely using dev environments. Git-enabled version control enables collaboration and a return to previous states.
Test and Document
Test every model prior to production, and share dynamically generated documentation with all data stakeholders.
Develop
Write modular data transformations in .sql or .py files – dbt handles the chore of dependency management.
The new standard for data transformation
Develop faster
Replace boilerplate DDL/DML with simple SQL SELECT statements that infer dependencies, build tables and views, and run models in order. Develop code that writes itself with macros, ref statements, and auto-complete commands in the Cloud IDE. Make use of Python packages to speed up complex analysis.
Work from the same assumptions
dbt's pre-packaged and custom testing helps developers create a “paper-trail” of validated assumptions for data collaborators. Auto-generated dependency graphs and dynamic data dictionaries promote trust and transparency for data consumers.
Deploy with confidence
Build observability into transformation workflows with in-app scheduling, logging, and alerting. Protection policies on branches ensure data moves through governed processes including dev, stage, and prod environments generated by every CI run.
Eliminate silos
Now your data science team can build models that connect with those built by the analytics team, each using the language they prefer. dbt supports modeling in SQL or Python, enabling a shared workspace for everyone that works on analytic code.
Governance
Eliminate data doubt with version control, testing, logging, and alerting. Snapshot changes over time and provide open access to hosted documentation.
Security
Manage risk with SOC-2 compliance, CI/CD deployment, RBAC, and ELT architecture. Check out our Security page for more information.
Transform your data where it lives
Whether your analytics data is stored in a cloud warehouse, data lake, lake house or beach house - you can transform, test and document it with dbt.
We think empowering analysts to own the data transformation pipeline is the only way to build a productive analytics team at scale. dbt makes it easier to do data modeling the right way, and harder to do it the wrong way.
Community and support
dbt Cloud
dbt Cloud™ is the fastest and most reliable way to deploy dbt. Develop, test, schedule, and investigate data models all in one web-based UI.
Create a free accountdbt Core
dbt Core™ is an open source command line tool that enables data teams to transform data using analytics engineering best practices.
Install dbt Core