It is very nice that dbt gives us the capability to write out our transformation logic as application code. The process of integrating it with Git implies that our whole team may contribute to data models and track changes without hassles, and revert changes as well. Even the separation of the development and production environment out of the box is a tremendous advantage, so we can ensure that we are testing new things without necessarily influencing live reports. Lastly, the automated documentation generation process has made the data models so simple to comprehend, even to the business users, without ever having the touch a SQL. Review collected by and hosted on G2.com.

The initial set up of dbt can be a little fiddly at times and with a mix of operating systems and local database connections. It also lacks its own scheduler, so still we will require an external orchestration tool to carry out our data pipelines. The more advanced Jinja templating and macros proved to be more cumbersome to our team to learn than the simpler SQL. Review collected by and hosted on G2.com.

I liked that it completely changed the way my team and I interact with information. With DBT, I know our customers, usage metrics are accurate and consistent, and it's fantastic because it prioritizes functionality to validate our product hypotheses. I loved DBT because it relies on reliable data to make decisions. Review collected by and hosted on G2.com.

For team members unfamiliar with engineering workflows, doing so could be challenging. Review collected by and hosted on G2.com.

dbt core for data transformations on BigQuery Review collected by and hosted on G2.com.

The change in the business model to focus on monetization has been notable. Review collected by and hosted on G2.com.

What I liked most was being able to transform models, which is easy with DBT because its been extremely good and useful, with understandable documentation, and it speed up development time. The documentation is interactive , managed, and essential. It works well now. I like most of its features. Review collected by and hosted on G2.com.

The only issue I had a while back was that we received an error with no error code, which was difficult to troubleshoot because it wasn't very informative. Review collected by and hosted on G2.com.

It is inexpensive to use the DBT cloud service. DBT itself is free for a self-hosted environment. Very easy to set up local dev/test. Quite intuitive to use. Flexibility of macros, functions, Jinja, etc. Easily integratable with Snowflake, Clickhouse, Postgres, etc. I've never had to reach out to DBT's customer support even once in the 5+ years I've been using it. Review collected by and hosted on G2.com.

I wish that more Jinja syntax was supported (like Ansible). I also wish that more functionality was default in the product (e.g. auto-generated YAML schemas). I was really excited about the semantic layer functionality that DBT released but it seems like the final product was a disappointment and it doesn't have some of the functionality that other layers have like symmetric aggregates. Review collected by and hosted on G2.com.

I really appreciate how DBT brings software engineering principles to SQL, transforming our SQL into a dependable data model. This helps resolve reporting errors that would otherwise consume a significant amount of our IT team's time. Review collected by and hosted on G2.com.

I didt really like that it requires mastering concepts like Jinja and Git. Review collected by and hosted on G2.com.

I like to simplify the transformation of the data and take advantage of SQL and Python in DBT in addition their skills are ideal for our needs. Finally I liked it to be relatively economical to compare other similar tools. Review collected by and hosted on G2.com.

The negative for me is that sometimes the analytical development process can slow down a bit. Review collected by and hosted on G2.com.

I like that it has error-detection capabilities and offers a wide range of connections. It makes it easy to sync analytics data and has a simple user interface that makes data management easy. I was able to easily navigate through the pages using the side panel. Review collected by and hosted on G2.com.

I'm satisfied with the platform, I haven't encountered any issues yet. The team has been excellent with us, they've developed an impressive management tool. Review collected by and hosted on G2.com.

Data transformation logic can be expressed in SQL

Data can be transformed in batch

Ease to use, it has lot of good features similar in Django web application Review collected by and hosted on G2.com.

Joining multiple database types is not possible. Ie., combining two databases like oracle and mysql.

Persistent cluster is required for running the sql statements.

Like Presto/Hive it can’t be connected to BI Directly Review collected by and hosted on G2.com.

The platform stands out for its exceptional consistency and timeliness. It's intuitive and well-designed, making it easy for our team to get up and running quickly, without the usual complexity or overhead. One of the most notable benefits for us has been its cost-effectiveness. Review collected by and hosted on G2.com.

We've had a fantastic experience working with this platform and are delighted with the results. As our data needs have grown, the platform has adapted seamlessly. Review collected by and hosted on G2.com.