Dremio vs Snowflake comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Dremio
Ranking in Cloud Data Warehouse
11th
Average Rating
8.6
Number of Reviews
6
Ranking in other categories
Data Science Platforms (10th)
Snowflake
Ranking in Cloud Data Warehouse
1st
Average Rating
8.4
Number of Reviews
95
Ranking in other categories
Data Warehouse (1st)
 

Mindshare comparison

As of July 2024, in the Cloud Data Warehouse category, the mindshare of Dremio is 4.8%, up from 2.4% compared to the previous year. The mindshare of Snowflake is 30.4%, up from 24.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
Unique Categories:
Data Science Platforms
5.3%
Data Warehouse
15.2%
 

Featured Reviews

VA
Feb 13, 2023
Quick database capabilities but sometimes shows minor errors
I can visualize traffic from BI and Tableau on the same page and have my tables and schema on the same page. The data link comprises everything. If I want one structure, I connect it to a big table in the hive and the data team that could read my SQL work on my tables, schemas, table structures and…
MF
Mar 1, 2023
Straightforward deployment, stable, and scalable
I mostly build or design data warehouse analytics solutions using Snowflake The productivity across the teams that use Snowflake I believe is higher than it would be without the solution. Snowflake has three great features: Snowpiping is proving to be very valuable, Time Travel is excellent, and…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable feature of Dremio is it can sit on top of any other data storage, such as Amazon S3, Azure Data Factory, SGFS, or Hive. The memory competition is good. If you are running any kind of materialized view, you'd be running in memory."
"Everyone uses Dremio in my company; some use it only for the analytics function."
"We primarily use Dremio to create a data framework and a data queue."
"Dremio gives you the ability to create services which do not require additional resources and sterilization."
"Dremio enables you to manage changes more effectively than any other data warehouse platform. There are two things that come into play. One is data lineage. If you are looking at data in Dremio, you may want to know the source and what happened to it along the way or how it may have been transformed in the data pipeline to get to the point where you're consuming it."
"Dremio allows querying the files I have on my block storage or object storage."
"Time travel is one feature that really helps us out."
"It's ultra-fast at handling queries, which is what we find very convenient."
"It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud. It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it."
"The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power."
"The solution is very easy to use."
"Snowflake is scalable both in terms of the amount of data that you can run through it and the number of users that engage with it."
"The tool's performance is good. I think it's the best in the game right now. It usually charges per query. For example, if you run a SQL query on Snowflake with the same number of data records, it would take less than half the time compared to running it on Microsoft. It has good documentation. You can pick up Snowflake if you have previous knowledge of SQL."
"All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse."
 

Cons

"I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported."
"It shows errors sometimes."
"Dremio doesn't support the Delta connector. Dremio writes the IT support for Delta, but the support isn't great. There is definitely room for improvement."
"They have an automated tool for building SQL queries, so you don't need to know SQL. That interface works, but it could be more efficient in terms of the SQL generated from those things. It's going through some growing pains. There is so much value in tools like these for people with no SQL experience. Over time, Dermio will make these capabilities more accessible to users who aren't database people."
"We've faced a challenge with integrating Dremio and Databricks, specifically regarding authentication. It is not shaking hands very easily."
"Dremio takes a long time to execute large queries or the executing of correlated queries or nested queries. Additionally, the solution could improve if we could read data from the streaming pipelines or if it allowed us to create the ETL pipeline directly on top of it, similar to Snowflake."
"If you go with one cloud provider, you can't switch."
"Some SQL language functions could be included."
"The solution could improve by allowing non-structured data, such as PDFs, images, or videos. We cannot see the data."
"From the documentation, the black box is not very descriptive. Snowflake does not reveal how exactly the data is processed or sourced."
"The UI could improve because sometimes in the security query the UI freezes. We then have to close the window and restart."
"Support needs improvement, as it can take several days before you get some initial support."
"The solution could use a little bit more UI."
"They should improve the reporting tools."
 

Pricing and Cost Advice

"Right now the cluster costs approximately $200,000 per month and is based on the volume of data we have."
"Dremio is less costly competitively to Snowflake or any other tool."
"It is pay-as-you-go. Its cost is in the medium range."
"The price of Snowflake is quite reasonable."
"Snowflake is expensive, but when I consider what we get for that price, it's fair. I rate the solution three out of five for affordability, right in the middle."
"Part of the problem with the pricing is that it is very difficult for businesses to get an idea of how expensive it might be until they actually start using Snowflake."
"Snowflake goes by credits. For a financial institution where you have 5,000 employees, monthly costs may run up to maybe $5,000 to $6,000. This is actually based on the usage. It is mostly the compute cost. Your computing cost is the variable that is actually based on your usage. It is pay-per-use. In a pay-per-use case, you won't be spending more than $6,000 to $7,000 a month. It is not more than that for a small or medium enterprise, and it may come down to $100K per year. Storage is very standard, which is $23 a terabyte. It is not much for any enterprise. If you have even 20 terabytes, you are not spending more than $400 per month, which may turn out to be $2,000 to $3,000 per annum."
"There is a separation of storage and compute, so you only pay for what you use."
"There is a licensing for this solution and we purchased an enterprise license. Overall the solution is cost-effective."
"Pricing is based on usage. It is the most expensive of our data tools."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
792,694 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
31%
Computer Software Company
11%
Manufacturing Company
8%
Retailer
4%
Educational Organization
29%
Financial Services Firm
13%
Computer Software Company
10%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about Dremio?
Dremio allows querying the files I have on my block storage or object storage.
What is your experience regarding pricing and costs for Dremio?
Every tool has a value based on its visualization, and the pricing is worth its value.
What needs improvement with Dremio?
Dremio's interface is good, but it has a few limitations. I cannot do a lot of things with ANSI SQL or basic SQL. I cannot use the recursive common table expression (CTE) in Dremio because the supp...
What do you like most about Snowflake?
The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.
What is your experience regarding pricing and costs for Snowflake?
The product's price range falls between average to a bit expensive range. I think the tool is worth the money if you use it properly. It is difficult for me to speak about the number of users who u...
What needs improvement with Snowflake?
I don't think that the AI tools in Snowflake are good. AI tools in Snowflake can be improved. Even if the AI tools in Snowflake are good, I feel that it would be expensive. The cost of the AI part ...
 

Comparisons

 

Also Known As

No data available
Snowflake Computing
 

Learn More

Video not available
 

Overview

 

Sample Customers

UBS, TransUnion, Quantium, Daimler, OVH
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about Dremio vs. Snowflake and other solutions. Updated: July 2024.
792,694 professionals have used our research since 2012.