I find dbt very simple to use and get started with. Anyone with some SQL and YAML files can use it. It solves many problems related to data transformations, data quality, and data lineage. I like dbt Cloud for scheduling jobs, which is crucial for me, and I appreciate that I can schedule jobs in various environments based on my use case and get alerts too. I also enjoy the new AI feature, dbt-copilot, which helps with development, understanding code better, and writing dbt macros, which can be challenging. The initial setup was easy as it mostly required SQL expertise, and the training sessions were helpful. Overall, I love this tool.

dbt simplifies the process of building a solid data pipeline by offering a lot of features that would be difficult to implement from scratch. In particular, the SCD2 and incremental functionality helps remove a lot of overhead for developers and makes ongoing maintenance easier. There are also many other features that are great and contribute to a smoother overall workflow.

I have been using DBT every day in my project for the last two years, and I can say it is one of the best platforms for creating data models through SQL-based data transformations. DBT’s ease of integration has helped us save effort during code deployment. We integrated DBT with Git so we can work in parallel on multiple tasks across multiple models for a single requirement. Its ease of implementation also makes it simpler to understand DBT’s benefits and has helped improve our efficiency. The command-line interface and the IDE environment make it easier for us to manage data and execute data models. DBT also has its own test case preparation features, which help us validate both our data model changes and the data being populated through DBT models. If we run into any product-related issues, there is a customer support team that is always ready to guide us through our blockers.