www.getdbt.com Open in urlscan Pro
2406:da18:880:3802:1312:af95:7fd9:2eb6  Public Scan

URL: https://www.getdbt.com/product/what-is-dbt/
Submission: On June 12 via api from NZ — Scanned from NZ

Form analysis 0 forms found in the DOM

Text Content

Learn with us at our weekly demos and see dbt Cloud in action!

Monday, Oct 16, 2023: Join data practitioners worldwide at Coalesce 2023!

Wednesday, Jun 21, 2023: Taming the Chaos of Data Democracy | Register now!

 * Login

Search...
 * Product
   
   OVERVIEW
   
   
   WHAT IS DBT?
   
   dbt is an intuitive, collaborative platform that lets you reliably transform
   data using SQL and Python code.
   
   Learn more
   
   BY USE CASE
   
    * For Data Modeling
      
      Create modular data models you can reuse and build upon
   
    * For Data Testing
      
      Test before production to ship reliable, accurate data
   
    * For Data Documentation
      
      Automate your documentation for ease and accessibility
   
   IMPLEMENTATION
   
    * Semantic Layer
    * Integrations
    * Enterprise
    * Success Stories
    * Product Tour

 * Docs
    * Documentation
      
      Find resources in this collection of dbt guides and user forums
   
    * Core Concepts
      
      Grasp dbt’s technical basics by exploring these core concepts
   
    * Getting Started Guide
      
      Start using dbt with this series of step-by-step tutorials
   
   PLATFORMS
   
    * BigQuery
    * Databricks
    * Redshift
    * Snowflake
    * Starburst
   
   View all
 * Company
    * Who We Are
      
      Meet our leadership team and read the latest news about dbt
   
    * Our Values
      
      Learn about the values that fuel dbt and shape our direction
   
    * Diversity, Equity & Inclusion
      
      Read about our commitment to inclusivity and diverse voices
   
    * Find a Partner
      
      Find collaborative Partners in our searchable database
   
    * Become a Partner
      
      Join the dbt Partner program for valuable benefits and trainings
   
    * Services
      
      Let our experts help your team with customized guidance

 * Learn
   
   RESOURCES
   
    * Developer Blog
      
      Read use cases and gain insights from the dbt Community
   
    * Blog
      
      Catch up the latest dbt news, product updates, and events
   
    * Resource Hub
      
      Explore a centralized collection of tutorials and case studies
   
    * Training
      
      Attend a free course to learn dbt in a structured and guided way
   
    * Certification
      
      Validate your skills with an official dbt Certification
   
    * Events & Meetups
      
      Attend meetups, conferences, and demos in person and online

 * Community
    * About the Community
      
      Learn about the benefits of the dbt Community
   
    * Join the dbt Community
      
      Sign up to meet new peers and share what you know
   
    * Discourse Forum
      
      Ask questions and learn from other dbt practitioners

 * Pricing
 * Book a demo
 * Create a free account

 * Book a demo
 * Create a free account
 * Login


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.

Create a free account Book a demo


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.

STARBURST

AWS REDSHIFT

DATABRICKS

GOOGLE BIGQUERY

SNOWFLAKE

Browse supported adapters

> 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.

James Densmore Director of Data Infrastructure


COMMUNITY AND SUPPORT

Join


JOIN THE WORLD’S LARGEST ANALYTICS ENGINEERING COMMUNITY

Join now
Share


SHARE CODE AND IDEAS ON THE COMMUNITY FORUM

Visit the forum
Meet


GET TOGETHER AND LEARN AT DBT EVENTS

Find a Meetup


DBT CORE

dbt Core™ is an open source command line tool that enables data teams to
transform data using analytics engineering best practices.

Install the CLI


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 account


PRODUCT

 * What is dbt?
 * Case studies
 * Integrations
 * Pricing


FOR DEVELOPERS

 * Documentation
 * Getting Started Guide
 * Supported Data Platforms
 * Developer Blog


COMPANY

 * About Us
 * Diversity, Equity & Inclusion
 * CareersWe're Hiring!
 * Company Blog


RESOURCES

 * Resource Hub
 * dbt Learn
 * Certification
 * Events


COMMUNITY

 * Join the Community
 * Become a Contributor
 * Open Source dbt Packages
 * Community Forum


SUPPORT

 * Contact Support
 * Professional Services
 * Find a Partner
 * Become a Partner


READ THE ROUNDUP

The internet's most useful articles on analytics engineering and its adjacent
ecosystem. Curated by Tristan Handy and Anna Filippova.

Read Now


CONNECT WITH US

GitHub LinkedIn Twitter YouTube
 * © 2023 dbt Labs, Inc. All Rights Reserved.
 * Terms of Use
 * Privacy Policy
 * Security
 * Report a Problem
 * Cookies Settings




PRIVACY PREFERENCE CENTER

When you visit any website, it may store or retrieve information on your
browser, mostly in the form of cookies. This information might be about you,
your preferences or your device and is mostly used to make the site work as you
expect it to. The information does not usually directly identify you, but it can
give you a more personalized web experience. Because we respect your right to
privacy, you can choose not to allow some types of cookies. Click on the
different category headings to find out more and change our default settings.
However, blocking some types of cookies may impact your experience of the site
and the services we are able to offer.
More information
Allow All


MANAGE CONSENT PREFERENCES

STRICTLY NECESSARY COOKIES

Always Active

Strictly necessary cookies are necessary for the site to function properly and
cannot be switched off in our systems. These cookies are usually only set in
response to actions made by you that amount to a request for services, such as
setting your privacy preferences, logging in, or filling in forms. You can set
your browser to block or alert you about these cookies, but blocking these
cookies will prevent the site from functioning properly. These cookies typically
do not store personal data.

PERFORMANCE COOKIES

Always Active

Performance cookies allow us to count visits and traffic sources so we can
measure and improve the performance of our sites. These cookies help us
understand how our sites are being used, such as which sites are the most and
least popular and how people navigate around the sites. The information
collected in these cookies are aggregated, meaning that the do not relate to you
personally. Opting out of these cookies will prevent us from knowing when you
have visited our site and will prevent us from monitoring site performance. In
some cases, these cookies may be sent to our third party service providers to
help us manage these analytics.

TARGETING COOKIES

Always Active

Targeting cookies may be set through our site by our advertising partners. They
may be used by those companies to build a profile of your interests and show you
relevant advertisements on other sites. These cookies do not store directly
personal information, but are based on uniquely identifying your browser and
device. If you do not allow these cookies, you will experience less targeted
advertising.

FUNCTIONAL COOKIES

Always Active

Functional cookies enable our sites to provide enhanced functionality and
personalization. They may be set by us or by third party service providers whose
services we have added to our sites. If you reject these cookies, then some or
all of these services may not function properly.

Back Button


BACK



Search Icon
Filter Icon

Clear
checkbox label label
Apply Cancel
Consent Leg.Interest
checkbox label label
checkbox label label
checkbox label label

Confirm My Choices