DBT is great for organizing data models. It is user friendly, integrates well with other tools, and they had a great onboarding process. Review collected by and hosted on G2.com.

In dbt Cloud, I cant work on two different branches at the same time in different browsers. Review collected by and hosted on G2.com.

I worked on DBT for 2 years as a data engineer , It is helpful in writing dynamic SQL queries by creating models and we can write pyspark code. Using both features we can do complex data transformations. Proper lineage is an added advantage Review collected by and hosted on G2.com.

DBT alone is not better , it should be integrated with other warehouses such as Snowflake, where there are other options in market which has both . Review collected by and hosted on G2.com.

All I need is to write some SQL select statements and specify materialisation type. My table will be created with the type of load I want to perform.

Support tickets are resolved quickly from support team. Review collected by and hosted on G2.com.

Sometimes the error is not described aptly. This makes parsing error and debugging difficult. Review collected by and hosted on G2.com.

Useage of sql.

Incremental strategies - which makes append , merge and full refresh easy.

Snapshots - which makes building scd type 2 model error free.

High Availability - we are using Dbt cloud, i rarely see failure in pipelines.

Tests - which helps to validate the data.

Configuration is ease. Review collected by and hosted on G2.com.

During development sometimes - changes are cached.So changes will not reflect ,which require removal of target folder or deps or clean to resolve it. Review collected by and hosted on G2.com.

You would feel really strange at first but after you start the integration will notice how easy to use it is. Great Documentation and community. Review collected by and hosted on G2.com.

The initial deployment is not ideal, and it would be beneficial to have a interface for dbt Core to support analysts who do not use Git on a daily basis but still take advantage of its benefits. Review collected by and hosted on G2.com.

beautifull data lineage

easy to use and implement

dbt learning courses provided by dbt are super usefull

data sharing and orchestration is super easy

development in cloud ide is very good

custoer support is extreme fast and efficient

integration with snowflake and GitHub is easy

Using daily this tool for building data models Review collected by and hosted on G2.com.

Beta features are very slow releasing. Rest all GREAT Review collected by and hosted on G2.com.

It's simple, SQL based approach and easy to version control. Review collected by and hosted on G2.com.

Challenging to manage large scale and complex dependencies Review collected by and hosted on G2.com.

dbt's ability to streamline data workflows is excellent Review collected by and hosted on G2.com.

While dbt is great, for extremely large datasets or highly complex transformations, native SQL compilation might still require deep optimization knowledge or workarounds to achieve peak performance Review collected by and hosted on G2.com.

The most and best things i like in dbt are it not only helps in creating transformations but can also helps in managing and performing transformations in a view and integrates easily with Big-query

i can use and configure the transformation as per the object like table,view or incrementalalong with features like auto-generated lineage graphs and can perform native testing with few lines of codes in a YAML file and can able to re use them. Review collected by and hosted on G2.com.

There is not much about to dislike in dbt the reusable code can be little bit confusing and jumping from one branch to another can be frustrating Review collected by and hosted on G2.com.

1. The documentation it generates when all the models are designed. It clearly defines which intermediate and final layers are connected to each other.

2. The incremental model runs greatly helped me in optimizing large data models as I was dealing with billions of rows of data. Review collected by and hosted on G2.com.

I did not come across any difficulty in learning DBT as it was pretty basic and I also applied SQL fluff to streamline my coding. As a user, I did not find much difficulty in operating through dbt. Review collected by and hosted on G2.com.