Introducing G2.ai, the future of software buying.Try now
Compare Amazon Redshift and Snowflake 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Starburst
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Alteryx
Visit Website
At a Glance
Market Segments
Mid-Market (39.5% of reviews)
Enterprise (44.7% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
$2 Compute/Hour
Amazon Redshift
Star Rating
(397)4.3 out of 5
Market Segments
Mid-Market (39.5% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plansSnowflake
Star Rating
(657)4.6 out of 5
Market Segments
Enterprise (44.7% of reviews)
Entry-Level Pricing
$2 Compute/Hour
Free Trial is available
Browse all 4 pricing plansSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Amazon Redshift excels in its data compression capabilities, with a score of 8.4, which helps in optimizing storage costs. In contrast, Snowflake shines with a higher score of 8.8, indicating better overall efficiency in data storage and management.
- Reviewers mention that Snowflake's cloud deployment is rated at 9.2, showcasing its superior scalability and flexibility compared to Amazon Redshift's score of 8.9. This makes Snowflake a more attractive option for businesses looking to scale their operations seamlessly.
- G2 users highlight that Snowflake offers better data integration features, scoring 8.9, while Amazon Redshift follows closely with a score of 8.8. This slight edge for Snowflake suggests it may provide a more comprehensive suite of tools for integrating various data sources.
- Users on G2 report that Amazon Redshift's query language is highly rated at 9.3, which is a significant advantage for users who prioritize complex query handling. Snowflake, while still strong, scores slightly lower at 8.6, indicating that Redshift may be more favorable for advanced analytics tasks.
- Reviewers mention that Snowflake's auto recovery feature is rated at 9.2, which is higher than Amazon Redshift's score of 8.2. This suggests that Snowflake may provide a more robust solution for data reliability and disaster recovery scenarios.
- Users say that both platforms have strong data security measures, but Snowflake edges out with a score of 9.0 compared to Amazon Redshift's 8.8. This indicates that Snowflake may offer more comprehensive security features, which is crucial for organizations handling sensitive data.
Pricing
Entry-Level Pricing
Amazon Redshift
RA3.4xlarge
$1.22 - $3.26
Per hour
On-demand, 1-Year, or 3-Year Terms
- Commit to save up to 34%
Snowflake
Standard
$2
Compute/Hour
Compute usage is billed on a per-second basis, with a minimum of 60 seconds. You can secure price discounts with pre-purchased Snowflake capacity options.
- Complete SQL Data Warehouse
- Secure Data Sharing across regions / clouds
- Premier Support 24 x 365
Free Trial
Amazon Redshift
Free Trial is available
Snowflake
Free Trial is available
Ratings
Meets Requirements
8.7
281
9.1
497
Ease of Use
8.7
281
9.0
533
Ease of Setup
8.6
138
8.9
318
Ease of Admin
8.4
128
8.6
202
Quality of Support
8.5
264
8.7
454
Has the product been a good partner in doing business?
8.7
127
9.0
203
Product Direction (% positive)
8.8
252
9.2
467
Features by Category
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
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
28
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
Data Management
8.8
133
|
Verified
9.0
179
|
Verified
8.4
125
|
Verified
8.9
165
|
Verified
8.8
131
|
Verified
9.1
172
|
Verified
8.0
127
|
Verified
8.3
167
|
Verified
7.6
102
|
Verified
8.2
149
|
Verified
8.3
118
|
Verified
8.8
152
|
Verified
Integration
7.9
101
|
Verified
8.3
139
|
Verified
8.7
128
|
Verified
8.9
167
|
Verified
8.6
119
|
Verified
8.9
158
|
Verified
Deployment
8.1
102
7.8
139
|
Verified
8.9
130
|
Verified
9.3
171
|
Verified
Performance
8.9
134
|
Verified
9.3
174
|
Verified
Security
8.7
126
|
Verified
8.9
164
|
Verified
8.8
128
|
Verified
9.1
175
|
Verified
Generative AI
7.3
20
8.0
79
7.2
19
8.1
80
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
87
Storage
8.4
53
9.2
44
8.4
56
9.2
44
Availability
8.6
47
9.1
39
8.2
50
9.2
37
8.4
48
9.2
41
Performance
8.2
48
9.2
44
Security
8.7
47
9.1
44
8.4
52
9.2
45
8.1
47
8.9
38
8.5
48
9.2
38
Support
7.9
43
9.2
36
8.5
47
9.1
35
Centralized computation
Not enough data
9.3
25
Localized computation
Not enough data
9.0
24
Database
Not enough data
8.9
97
Not enough data
9.3
100
Not enough data
9.3
94
Integrations
Not enough data
8.6
76
Not enough data
8.7
81
Platform
Not enough data
9.1
91
Not enough data
9.0
97
Not enough data
8.7
81
Processing
Not enough data
9.3
95
Not enough data
9.1
94
Data Transformation
Not enough data
9.2
86
Not enough data
9.4
86
Connectivity
Not enough data
8.5
78
Not enough data
8.7
79
Not enough data
9.1
80
Not enough data
9.1
81
Operations
Not enough data
8.6
83
Not enough data
9.2
79
Not enough data
8.9
75
Not enough data
8.8
80
Not enough data
8.7
77
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
Amazon Redshift and Snowflake are categorized as Columnar Databases, Data Warehouse, and Big Data Integration Platforms
Unique Categories
Amazon Redshift has no unique categories
Snowflake is categorized as Data Clean Room, MLOps Platforms, Big Data Processing and Distribution, Big Data Analytics, Database Management Systems (DBMS), and Data Science and Machine Learning Platforms
Reviews
Reviewers' Company Size
Amazon Redshift
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Snowflake
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
15.5%
Computer Software
12.7%
Financial Services
7.7%
Retail
5.2%
Telecommunications
4.7%
Other
54.1%
Information Technology and Services
13.7%
Computer Software
13.0%
Financial Services
10.5%
Marketing and Advertising
4.8%
Hospital & Health Care
3.8%
Other
54.3%
Alternatives
Discussions
Should I use with a data mart for a frontend tool that make request on it ?
3 Comments
NM
Hi Mehdi
Can you elaborate your question?
AWS Redshift is a DataBase/Data Warehouse service, which is Ideal for Analytical use cases.
You can...Read more
When can I use Amazon redshift?
3 Comments
PG
Redshift is big data warehousing solution to handle petabytes of data and also for real time decisions. If you want highly optimized data warehousing...Read more
What's the best way to manage change data capture in Snowflake?
4 Comments
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
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
Snowflake - how to connect to Snowflake using NodeJS
2 Comments
DW
Does this help? https://www.ameexusa.com/blogs/connecting-node-js-snowflakeRead more
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
