TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    dbt

    Score9 out of 10
    N/Adbt is an SQL development environment, developed by Fishtown Analytics, now known as dbt Labs. The vendor states that with dbt, analysts take ownership of the entire analytics engineering workflow, from writing data transformation code to deployment and documentation. dbt Core is distributed under the Apache 2.0 license, and paid Teams and Enterprise editions are available.

    $0

    per month per seat

    Snowflake

    Score8.9 out of 10
    N/AThe Snowflake Cloud Data Platform is the eponymous data warehouse with, from the company in San Mateo, a cloud and SQL based DW that aims to allow users to unify, integrate, analyze, and share previously siloed data in secure, governed, and compliant ways. With it, users can securely access the Data Cloud to share live data with customers and business partners, and connect with other organizations doing business as data consumers, data providers, and data service providers.N/A
    Pricing
    dbtSnowflake
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    dbtSnowflake
    Free Trial
    YesYes
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    dbtSnowflake
    Considered Both Products
    dbt Labs
    Chose dbt
    dbt is very flexible and can fit into most data pipelines. This is a pro for most organizations that aren't fully bought into one platform (Google Cloud, etc.)
    Incentivized
    Chose dbt
    Matillion is graphical versus dbt, which is SQL code-based (that, of course, is a matter of personal preference and not an objective advantage). The integrated testing, documentation generation, lineage, etc., were additional criteria that led us to choose dbt.
    Incentivized
    Chose dbt
    I actually don't know what the alternative to dbt is. I'm sure one must exist other than more 'roll your own' options like Apache Airflow, say, bu tin terms of super easy managed/cloud data transforms, dbt really does seem to be THE tool to use. It's $50/month per dev, BUT …
    Incentivized
    Chose dbt
    I haven't come across anything like DBT before.
    Incentivized
    Chose dbt
    dbt is great because of its transformation capabilities
    Incentivized
    Chose dbt
    dbt fits much better in our stack, where we're using specialized tools to support our ELT approach.
    Incentivized
    Snowflake Computing
    Chose Snowflake
    These are comparable products that can make sense depending on the specific needs of your organization. All are certainly serviceable and have varying pros and cons. Snowflake seems to provide the greatest degree of flexibility and easy scalability as new data gets brought into …
    Incentivized
    Chose Snowflake
    Snowflake has an attractive pricing model with auto-suspend and auto-resume and pay per use. AWS Redshift requires higher administrative efforts to maintain and scale the platform whereas with Snowflake those admin tasks are not needed or automatically taken care of.
    Incentivized
    Chose Snowflake
    Each of the other solutions were cloud vendor specific, Snowflake can ride on either Amazon Web Services, Microsoft Azure, or Google Cloud. The fact that they are ANSI-sql compliant and have an effective means of offloading data makes them portable and easy to sell to teams …
    Incentivized
    Chose Snowflake
    In my experience running the data management practice at InterWorks, we believe that cloud data warehouse products will eventually serve the majority of data warehousing use cases and power data analytics at most companies. Of this cohort, we believe that Snowflake is the best …
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    No answers on this topic
    Delivers good value for the price
    No answers on this topic
    No answers on this topic
    Happy with the feature set
    No answers on this topic
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    Features
    dbtSnowflake
    Data Transformations
    Comparison of Data Transformations features of dbt and Snowflake
    Feature
    dbt
    9.5
    7 Ratings
    Snowflake
    -
    Ratings
    Simple transformations10.07 Ratings00 Ratings
    Complex transformations9.07 Ratings00 Ratings
    Data Modeling
    Comparison of Data Modeling features of dbt and Snowflake
    Feature
    dbt
    9.0
    7 Ratings
    Snowflake
    -
    Ratings
    Data model creation9.57 Ratings00 Ratings
    Metadata management8.57 Ratings00 Ratings
    Business rules and workflow9.07 Ratings00 Ratings
    Collaboration10.05 Ratings00 Ratings
    Testing and debugging8.07 Ratings00 Ratings
    User Ratings
    dbtSnowflake
    Likelihood to Recommend
    10.0
    (9 ratings)
    9.2
    (43 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    10.0
    (2 ratings)
    Usability
    9.5
    (2 ratings)
    9.3
    (19 ratings)
    Support Rating
    -
    (0 ratings)
    9.9
    (8 ratings)
    Contract Terms and Pricing Model
    -
    (0 ratings)
    8.0
    (1 ratings)