Logo of dbt

dbt

Last updated on

Company health

Employee growth
32% increase in the last year
Web traffic
13% decrease in the last quarter
Financing
November 2021 - $414M

Reviews

G2
4.8/5
(156)
Glassdoor
3.7/5
(44)

dbt description

dbt is a data transformation tool that helps data teams work together more efficiently. It allows anyone who knows SQL to build data pipelines by providing a framework for writing, testing, and deploying code. This helps companies deliver reliable data products faster and cheaper by standardizing how data is processed and documented within their data warehouse. dbt integrates with popular data platforms like Snowflake, Databricks, and BigQuery.


Who is using dbt?

New Relic is using dbt
New Relic
CHG Healthcare is using dbt
CHG Healthcare
Virgin Media is using dbt
Virgin Media
Nasdaq is using dbt
Nasdaq
Vestas is using dbt
Vestas
BHP is using dbt
BHP
HubSpot is using dbt
HubSpot
TaskRabbit is using dbt
TaskRabbit
JetBlue Airways is using dbt
JetBlue Airways
Thermo Fisher Scientific is using dbt
Thermo Fisher Scientific
Zapier is used by New Relic, CHG Healthcare, Virgin Media, Nasdaq, Vestas, BHP, HubSpot, TaskRabbit, JetBlue Airways, Thermo Fisher Scientific.

Who is dbt best for

dbt is a popular choice for data teams who want to streamline their data transformation workflows using SQL. Users highlight the platform's ease of use, robust testing capabilities, and excellent documentation generation as major advantages. However, some users desire more comprehensive column-level lineage and improved model documentation features. dbt is well-suited for teams familiar with SQL and looking for a tool to improve collaboration and accelerate data pipeline development.

  • dbt is a good fit for companies of all sizes, but it particularly shines for medium to large businesses.

  • While dbt can be used across various industries, it is particularly valuable for businesses with data-driven decision-making processes.


dbt features

Type in the name of the feature or in your own words tell us what you need
Supported

dbt fully supports performing data transformations using SQL queries.

Supported

dbt is well-suited to support smooth ETL processes by optimizing data transformation, integrating with version control, automating workflows, and ensuring data quality and governance.

Supported

Dbt integrates with popular data warehouse databases.

Supported

Dbt automatically tracks data lineage and transformations using a dependency graph.

Supported

Dbt allows defining data quality rules using SQL tests and assert functions.

Supported

Dbt offers data testing, monitoring, lineage, and CI/CD integration for data quality management.

Qualities

We evaluate the sentiment that users express about non-functional aspects of the software

Value and Pricing Transparency

Strongly positive
+1

Customer Service

Neutral
-0.2

Ease of Use

Strongly positive
+0.93

Reliability and Performance

Strongly positive
+0.87

Ease of Implementation

Rather positive
+0.47

Scalability

Rather positive
+0.6

dbt reviews

We've summarised 156 dbt reviews (dbt G2 reviews) and summarised the main points below.

Pros of dbt
  • The documentation it generates when all the models are designed. It clearly defines which intermediate and final layers are connected to each other.
  • The incremental model runs greatly helped me in optimizing large data models as I was dealing with billions of rows of data.
  • dbt is the best Transformation tool out there in the industry and I love dbt for its testing capabilities and modeling and semantic layer.
  • Ease of use and how easily you could maintain
Cons of dbt
  • It would be better if we have column level lineage available in dbt.
  • The documentation is not very extensive.
  • The scheduler will make it complete transformation tool for data engineers.
  • It should provide a tool to better enable model documentation.

dbt pricing

The commentary is based on 9 reviews from dbt G2 reviews.

While dbt offers a free version for individual developers, users mention the unclear pricing of the enterprise edition. However, they consistently emphasize that dbt's robust features and time-saving benefits make it a worthwhile investment for data teams of all sizes.

Users sentiment

Strongly positive
+1

See the dbt pricing page.

  • dbt has a free plan.

  • dbt has a free trial.

Developer

Free

The fastest way to get started with dbt Cloud. This plan includes a 14-day free trial of the Teams plan, browser-based IDE, job scheduling, one project, logging & alerting, data documentation, source freshness reporting, continuous integration, native support for GitHub and GitLab, US hosting, multi-factor authorization for logins.

Team

$100/mo/seat

Pay-as-you-go pricing for emerging dbt Cloud teams. This plan includes all features in the Developer plan plus one project, five read-only seats, unlimited concurrent running jobs, API access, outbound webhooks, and dbt Semantic Layer, powered by MetricFlow.

Enterprise

Custom

Scale dbt Cloud to the changing needs of your business. This plan includes all the features in the Team plan plus unlimited projects, single sign-on (SSO), multiple deployment regions, service level agreements (SLAs), professional services, role-based ACLs, fine-grained Git permissions, audit logging, native support for GitHub, GitLab, and Azure DevOps, and advanced CI.


dbt alternatives

  • Logo of Databricks Data Intelligence Platform
    Databricks Data Intelligence Platform
    Better for larger enterprises and in Healthcare and IT. It has more momentum and is better for open-source ecosystems. Users report slower cluster startup times and a need for better documentation.

  • dbt FAQ


    Reviewed by

    MK
    Michal Kaczor
    CEO at Gralio

    Michal has worked at startups for many years and writes about topics relating to software selection and IT management. As a former consultant for Bain, a business advisory company, he also knows how to understand needs of any business and find solutions to its problems.

    TT
    Tymon Terlikiewicz
    CTO at Gralio

    Tymon is a seasoned CTO who loves finding the perfect tools for any task. He recently headed up the tech department at Batmaid, a well-known Swiss company, where he managed about 60 software purchases, including CX, HR, Payroll, Marketing automation and various developer tools.