Cross Referencing of models, Macros and custom functions Review collected by and hosted on G2.com.

Error Messaging and no cross-query functionality Review collected by and hosted on G2.com.

Its simplicity and focus on transforming data in a reproducible and maintainable way. Review collected by and hosted on G2.com.

Sometimes,its learing curve can be steep for beginners and managing comples transformation might require advanced knowledge. Review collected by and hosted on G2.com.

we can made maintainalble and scalable data infrastructure, this make user easy for working with data, transforming data become easy, that is why we use it in our projects also provides some standardies features Review collected by and hosted on G2.com.

we can not able to load the data from source , we can only able to use data present in dataware houses, new users may face difficulties while learning, support also not that good from community Review collected by and hosted on G2.com.

DBT creates a new SQL-like syntax, use select statement and configuration file and headers to control behavior, make data model task more reliable and readable.

Easy for data analysis with existing basic SQL knowledge. Review collected by and hosted on G2.com.

We can rarely go through all features in dbt, since it is too much

Solutions are sometime duplicated. You can always find 2-4 ways to fulfill one purpose, and it can overwrite with each other.

DBT integration with CI/CD is not easy, even in DBT cloud since file is the first citizen in dbt world. You can only have them tested in dbt project, even for only unit tests. Review collected by and hosted on G2.com.

Cloud.dbt has proven to be an invaluable tool for our data modeling and analytics needs. Its seamless integration with cloud platforms, user-friendly interface, and robust features have significantly streamlined our workflow. The platform's automation capabilities have allowed our team to focus more on deriving insights from data rather than dealing with intricate modeling processes. The collaborative environment enhances team productivity, making it a standout solution for organizations aiming to elevate their data analytics game. I use it daily. Review collected by and hosted on G2.com.

Remember me during sign in doesn't work. Review collected by and hosted on G2.com.

Best in-class SQLCentric tool providing ELT, orchestration with Lineage on the models. Make the development much easier and help to concentrate more on the Business. Review collected by and hosted on G2.com.

DBT only supports SQL and Python models for now, and being an ELT, reading from external sources will not be possible, which makes DBT very constrained and the libraries quite limited. Review collected by and hosted on G2.com.

Can perform transformation using SQL statement. Very easy to perform Review collected by and hosted on G2.com.

Nothing much......simple and easy to use Review collected by and hosted on G2.com.

I like the most in MetricFlow is, it will simplify the code governance with autogenerated SQL. It will pull metrics into downstream applications.And also i like the UI most. Review collected by and hosted on G2.com.

Need to introduce more new interesting features in frequent releases.Should increate support of the application as well.Also better to support new intergrations. Review collected by and hosted on G2.com.

There's a lot that I really like about dbt, particularly in the way it automates so much of the 'grunt work' out of transforming data. It's now tough to imagine how we handled refreshing our data warehouse before dbt!

Specifically I am a fan of how dbt:

- Works out dependencies rather than you having to stay on top of which models need to be run before others

- Automates testing, running tests on a schedule rather than when you remember to run the testing!

- Handles version control, allowing you to keep track of changes

- Provides a straightforward way of handling separate development and production environments, so you can see the impact of your changes before making them live

- Has a very active community of Slack users and package developers Review collected by and hosted on G2.com.

This is quite minor, but with documentation it can be a bit onerous to keep .yml files up to date, as the formatting needs to be exact and it is not always obvious when something is wrong, for example, with the amount of tab spacing. Review collected by and hosted on G2.com.

dbt improves every facet of SQL transforms for analytics. My favorite features in order:

--Isolate each piece of business logic to a single model, ensuring that everything downstream inherits that definition.

--Build canonical fact tables, then combine those into report-ready aggregate marts. Once the fact tables are built, the time-to-data-mart is so fast.

--Automated testing for code and data quality

--Import code packages, either open source or private

--Managed interactive documentation Review collected by and hosted on G2.com.

The cloud IDE is still very much a work in progress. Already better than using a local IDE, but there are still enough quirks and bugs to be frustrating. Setting up a new project seems overly onerous--the same score of steps have to be done the same way, which seems like it could be just a copy/paste from a different project. Most implementations probably only have one project going, though, so that's a pain only us agency types feel. Review collected by and hosted on G2.com.