Introducing G2.ai, the future of software buying.Try now

Compare Dremio and Snowflake

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
Dremio
Dremio
Star Rating
(69)4.6 out of 5
Market Segments
Enterprise (47.6% of reviews)
Information
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Dremio
Snowflake
Snowflake
Star Rating
(666)4.6 out of 5
Market Segments
Enterprise (44.9% of reviews)
Information
Pros & Cons
Entry-Level Pricing
$2 Compute/Hour
Free Trial is available
Browse all 4 pricing plans
AI Generated Summary
AI-generated. Powered by real user reviews.
  • Users report that Snowflake excels in data compression with a score of 8.8, allowing for efficient storage and retrieval of large datasets, while Dremio's score of 8.6 indicates it is slightly less effective in this area.
  • Reviewers mention that Snowflake's data quality features are highly rated at 8.9, providing robust tools for ensuring data integrity, whereas Dremio's score of 8.2 suggests it may not meet the same standards.
  • G2 users highlight Snowflake's superior query language capabilities with a score of 9.3, making complex queries easier to handle compared to Dremio's score of 9.0, which, while still strong, may not offer the same level of flexibility.
  • Users on G2 appreciate Dremio's data lake integration capabilities, scoring 9.1, which allows for seamless data management across various sources, while Snowflake's score of 8.8 indicates it may not be as versatile in this aspect.
  • Reviewers say that Snowflake's ease of use is rated at 9.0, making it user-friendly for teams, while Dremio's score of 9.1 suggests it is also easy to use, but some users report a steeper learning curve for advanced features.
  • Users report that Dremio shines in data lake analytics with a score of 9.0, providing powerful tools for analyzing large datasets, while Snowflake's score of 8.6 indicates it may not be as specialized in this area.
Pricing
Entry-Level Pricing
Dremio
No pricing available
Snowflake
Standard
$2
Compute/Hour
Browse all 4 pricing plans
Free Trial
Dremio
Free Trial is available
Snowflake
Free Trial is available
Ratings
Meets Requirements
8.7
52
9.1
504
Ease of Use
9.2
53
9.0
540
Ease of Setup
8.4
47
8.9
325
Ease of Admin
7.8
29
8.6
204
Quality of Support
8.5
50
8.7
461
Has the product been a good partner in doing business?
9.1
28
9.0
205
Product Direction (% positive)
9.7
46
9.2
474
Features by Category
Not enough data
Not enough data
Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Self Service
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Advanced Analytics
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
9.2
12
Deployment
Not enough data
9.2
12
Not enough data
8.9
12
Not enough data
9.0
12
Not enough data
9.3
12
Not enough data
9.3
12
Deployment
Not enough data
9.3
10
Not enough data
9.5
10
Not enough data
9.5
10
Not enough data
9.5
10
Not enough data
9.3
10
Management
Not enough data
9.2
12
Not enough data
9.0
12
Not enough data
9.2
12
Not enough data
9.0
12
Operations
Not enough data
8.8
10
Not enough data
8.8
10
Not enough data
9.5
10
Management
Not enough data
9.2
10
Not enough data
9.3
9
Not enough data
9.0
10
Generative AI
Not enough data
8.7
10
Not enough data
8.3
10
Data Science and Machine Learning PlatformsHide 25 FeaturesShow 25 Features
Not enough data
8.6
31
System
Not enough data
9.2
28
Model Development
Not enough data
9.1
27
Not enough data
8.5
27
Not enough data
8.3
27
Not enough data
8.7
27
Model Development
Not enough data
8.7
27
Machine/Deep Learning Services
Not enough data
8.6
27
Not enough data
8.6
27
Not enough data
8.4
27
Not enough data
8.4
26
Machine/Deep Learning Services
Not enough data
8.5
27
Not enough data
8.5
24
Deployment
Not enough data
9.1
29
Not enough data
9.0
27
Not enough data
9.3
27
Generative AI
Not enough data
8.4
25
Not enough data
8.3
25
Not enough data
8.5
25
Agentic AI - Data Science and Machine Learning Platforms
Not enough data
8.2
13
Not enough data
8.2
13
Not enough data
8.3
13
Not enough data
8.5
13
Not enough data
8.2
13
Not enough data
8.3
13
Not enough data
8.2
12
8.4
26
8.7
210
Data Management
8.6
23
9.0
183
|
Verified
8.5
20
8.9
168
|
Verified
8.3
12
9.0
175
|
Verified
7.7
20
8.3
170
|
Verified
Feature Not Available
8.2
150
|
Verified
8.9
23
8.7
154
|
Verified
Integration
Feature Not Available
8.2
141
|
Verified
8.8
21
8.9
169
|
Verified
9.0
22
8.8
159
|
Verified
Deployment
8.7
15
7.8
140
|
Verified
8.5
19
9.2
175
|
Verified
Performance
8.3
21
9.2
178
|
Verified
Security
8.2
20
8.9
165
|
Verified
Feature Not Available
9.1
176
|
Verified
Generative AI
6.9
12
8.0
79
Not enough data
8.1
80
Database Management Systems (DBMS)Hide 10 FeaturesShow 10 Features
Not enough data
9.2
99
Management
Not enough data
8.9
83
Not enough data
9.2
83
Not enough data
9.5
88
Not enough data
9.0
86
Not enough data
9.1
87
Maintenance
Not enough data
9.3
85
Not enough data
9.0
84
Not enough data
9.3
85
Security
Not enough data
9.2
85
Not enough data
9.2
88
Not enough data
9.2
51
Storage
Not enough data
9.2
44
Not enough data
9.2
44
Availability
Not enough data
9.1
39
Not enough data
9.2
37
Not enough data
9.2
41
Performance
Not enough data
9.2
44
Security
Not enough data
9.1
44
Not enough data
9.2
45
Not enough data
8.9
38
Not enough data
9.2
38
Support
Not enough data
9.2
36
Not enough data
9.1
35
Not enough data
9.2
26
Centralized computation
Not enough data
9.3
25
Localized computation
Not enough data
9.0
24
Data as a Service (DaaS)Hide 7 FeaturesShow 7 Features
8.3
11
Not enough data
Data Management
8.6
11
Not enough data
8.8
11
Not enough data
Feature Not Available
Not enough data
Data as a Service
7.6
11
Not enough data
8.2
11
Not enough data
Architecture
8.2
11
Not enough data
8.6
11
Not enough data
Not enough data
Not enough data
Deployment & Integration - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Data Connectivity & Federation - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Data Modeling & Metrics - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Performance Optimization - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Governance - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Advanced Intelligence - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Agentic AI Enablement - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Big Data Processing and DistributionHide 10 FeaturesShow 10 Features
8.6
22
9.0
115
Database
Feature Not Available
8.9
98
Feature Not Available
9.3
101
Feature Not Available
9.3
95
Integrations
9.0
18
8.6
76
7.9
13
8.7
81
Platform
9.1
20
9.1
91
8.7
13
9.0
97
7.9
13
8.7
81
Processing
9.1
18
9.3
96
8.6
13
9.1
94
8.0
30
9.0
91
Data Transformation
Feature Not Available
9.2
86
9.2
24
9.4
86
Connectivity
8.6
22
8.5
78
Feature Not Available
8.7
79
8.9
23
9.1
80
8.9
25
9.1
81
Operations
7.2
25
8.6
83
7.1
25
9.2
79
7.8
27
8.9
75
7.7
21
8.8
80
7.0
21
8.7
77
Not enough data
Not enough data
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Dremio
Dremio
Snowflake
Snowflake
Dremio and Snowflake are categorized as Big Data Processing and Distribution, Big Data Analytics, and Data Warehouse
Reviews
Reviewers' Company Size
Dremio
Dremio
Small-Business(50 or fewer emp.)
11.1%
Mid-Market(51-1000 emp.)
41.3%
Enterprise(> 1000 emp.)
47.6%
Snowflake
Snowflake
Small-Business(50 or fewer emp.)
12.8%
Mid-Market(51-1000 emp.)
42.3%
Enterprise(> 1000 emp.)
44.9%
Reviewers' Industry
Dremio
Dremio
Financial Services
23.8%
Information Technology and Services
11.1%
Computer Software
7.9%
Marketing and Advertising
4.8%
Automotive
4.8%
Other
47.6%
Snowflake
Snowflake
Information Technology and Services
14.3%
Computer Software
13.0%
Financial Services
10.4%
Marketing and Advertising
4.7%
Hospital & Health Care
3.7%
Other
53.8%
Alternatives
Dremio
Dremio Alternatives
Databricks Data Intelligence Platform
Databricks Data Intelligence Platform
Add Databricks Data Intelligence Platform
Google Cloud BigQuery
Google Cloud BigQuery
Add Google Cloud BigQuery
Starburst
Starburst
Add Starburst
Denodo
Denodo
Add Denodo
Snowflake
Snowflake Alternatives
Google Cloud BigQuery
Google Cloud BigQuery
Add Google Cloud BigQuery
Databricks Data Intelligence Platform
Databricks Data Intelligence Platform
Add Databricks Data Intelligence Platform
Teradata Vantage
Teradata Vantage
Add Teradata Vantage
Alteryx
Alteryx
Add Alteryx
Discussions
Dremio
Dremio Discussions
What is a Dremio reflection?
1 Comment
Official Response from Dremio
A reflection is an optimized materialization of source data or a query, similar to a materialized view, that is derived from an existing table or view. A...Read more
Monty the Mongoose crying
Dremio has no more discussions with answers
Snowflake
Snowflake Discussions
What's the best way to manage change data capture in Snowflake?
4 Comments
Veera T.
VT
Please go through this link: https://docs.snowflake.com/en/user-guide/streams You might get a pertinent response from it. Please click on this link...Read more
which is best snowflake or My sql
2 Comments
Lee H.
LH
Depends on your needs. MySQL is open source/free. It or Postgres (another open source db) is good for pretty much any normal need. You can install on...Read more
What is the difference between Snowflake vs Redshift? Which one is Good to Learn.
2 Comments
David W.
DW
I've used both; Snowflake is superior in my view. Redshift certainly offers a lot of power being an AWS product, however Snowflake is more fully-featured....Read more