dbt Platform

What do you like best about the product?

DBT is a data building tool that is very easy to setup, to use and we are using it every day for our data transformation. It is very easy to integrate and leverage the tool with lots for features.

What do you dislike about the product?

Sometimes, it experiences server downtime.

What problems is the product solving and how is that benefiting you?

DBT is solving where our business analyst has data spread out in many different tables in our warehouse. Using DBT, I made datamart where I gathered all that information together so our BAs can get all the information they need from one single table.

What do you like best about the product?

The largest benefit of dbt to me is that it provides structure to data work. I use it regularly with the BigQuery and version control tools. The integration is comfortable and teamwork is facilitated. It did not add any delay during implementation and the feature set enables one to reuse logic rather than rewriting it. It has minimized the number of errors and saved me time on the review and updates.

What do you dislike about the product?

The negative side about dbt is that it becomes rigid when projects expand. Minor modifications in some cases need more readjustments than anticipated, and this makes me slow down. The problems of debugging failures are not always evident, particularly to more novice team members and this has an impact on the speed of delivery. Clean source data is also used in implementation and hence when inputs are messy, it only adds more workload rather than making it easy.

What problems is the product solving and how is that benefiting you?

Before using dbt, our changes were far between and difficult to handle. At this point, all things go in the same way, which is advantageous to the entire team. The coordination between systems was eliminated through integration and implementation provided a sense of ownership. I can perceive fewer errors, more harmonious work, and a higher level of trust in products. It has made daily work less stressful and less value building oriented.

What do you like best about the product?

What I appreciated most about DBT was its capability to automate the creation of form data models, allowing me to trust the data. I felt confident that the KPIs displayed were accurate, thanks to transformation logic that had been thoroughly tested and addressed, which I found particularly valuable.

What do you dislike about the product?

The learning curve could be smoother, and the user interface would benefit from some enhancements.

What problems is the product solving and how is that benefiting you?

My priority is to ensure that the strategic decisions I make are grounded in reliable and consistent data. DBT enables this by providing a column that transforms data into clear metrics, eliminating any mistrust in the data. This is achieved without requiring its own visualization, allowing the focus to remain on the quality of the data model. As a result, the agility and speed of reporting are significantly improved.

What do you like best about the product?

What I like most about dbt is that it brings software engineering best practices to SQL-based data transformations, making our SQL code base maintainable at scale. It has a clear model structure like staging, intermediate, and reporting layers. It provides macros and ref macros that make logic reusable, and the dependencies are really easy to understand. I appreciate its good collaboration with Git and integration with version control. Dbt has a strong documentation background, providing an auto-generated documentation site, so everyone is aware of what's happening in the project. The initial setup of dbt is really easy thanks to its great documentation, and it's available for almost all major data warehouses.

What do you dislike about the product?

One of the pain points is debugging and error troubleshooting. Error messages can really be vague, making it difficult to pinpoint which part of the core caused the failure. Also, large models are painful to debug. Query plan visibility inside dbt would be really helpful. Step by step execution for failed models would also be helpful.

What problems is the product solving and how is that benefiting you?

dbt provides a standard structure for our code base, eases data transformation with Jinja templating, organizes SQL scattered across tools, offers version control with Git, and includes data quality tests, making transformations maintainable and dependencies clear.

What do you like best about the product?

dbt runs well on Redshift, since that is what was mentioned over and over again in the notes; however, dbt simply compiles the SQL and the warehouse itself handles the heavy lifting. Using Git and Version Control for Data Models, is nice because it keeps the data model from exploding. dbt also integrates with our AWS infrastructure without requiring tears. The speed is sufficient, as it simply passes the work to the database; although, having the transformation logic in one location is helpful.

What do you dislike about the product?

The cost is becoming increasingly expensive and considering dbt is essentially a fancy SQL Compiler. dbt also has poor performance when handling un-structured data (although this may be due to Redshift); I'm unsure, everything seems to blend together. Additionally, the learning curve is very steep if you are not familiar with Jinja and setting-up YAML files properly.

What problems is the product solving and how is that benefiting you?

dbt allows us to scale the analytics engineering work so we are not running ad-hoc SQL scripts on a laptop. dbt separates the compute and storage logic, allowing us to define the "what", while it determines the "how". dbt automatically manages the dependency graphs, which is great, as I cannot handle tracking those manually.