dbt

What is dbt?

dbt is the industry standard for data transformation. Transform raw data into analysis-ready insights, and make data-driven decisions with confidence.

Global teams trust dbt

Thermo Fisher Scientific
Nasdaq
jetBlue
Anheuser-Busch Group
Virgin Media
Hubspot
Conde Nast
Vestas

Why dbt?

dbt allows your team to prepare data for analysis in a way that’s centralized, modular, and entirely open — all inside your cloud data platform.

The outcome: consistently dependable analytics for your organization. Less data downtime, a shorter request backlog, and most importantly, better business decisions across the board.

Centralized

dbt centralizes your business logic, making collaboration and updates easy. It transforms your data inside your cloud data platform — never moving it.

Modular

dbt breaks business logic into modular chunks that are easy to build on. Built-in testing ensures data quality, while documentation provides shared context.

Open

dbt is open-source and compiles directly into transparent SQL. It's supported by a thriving and growing community.

  • "dbt makes it easier to do data modeling the right way, and harder to do it the wrong way."

    James DensmoreDirector of Data Infrastructure
  • "The new workflow with dbt and Snowflake isn't a small improvement. It's a complete redesign of our entire approach to data that will establish a new strategic foundation for analysts at JetBlue to build on. "

    Benjamin Singleton Director of Data Science & Analytics
  • "With built-in tests, simple job scheduling, and easy deployment, dbt Cloud enabled us to focus on the business case rather than spending time on our data architecture setup."

    Rebecca Funk IT Business Partner

    Define transformations in code

    Code-based transformations offer unmatched flexibility, allowing everyone on the data team to collaborate in a common language. dbt is SQL-first and requires nothing more than SQL familiarity to get started.

    Treat data as a product

    Using software engineering best practices like testing, version control, and documentation allows data teams to deliver higher quality data to the business. That’s why software engineering capabilities are built directly into the dbt workflow.

    Get to know 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. Or you can access dbt Core, the open-source command line tool.

    Real-world applications of dbt

    Learn how organizations across industries transform data faster, cheaper, and more reliably with dbt Cloud.

    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.

    See dbt integrations

    Try dbt Cloud with your team

    dbt Cloud is the fastest and most scalable way to deploy dbt. Teams of varying skillsets can build, deploy, and optimize data models all in one web-based UI.