Compare Amazon Redshift and Snowflake 
At a Glance
Market Segments
Enterprise (39.8% of reviews)
Enterprise (47.0% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
$2 Compute/Hour
Amazon Redshift
Star Rating
(399)4.3 out of 5
Market Segments
Enterprise (39.8% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plansSnowflake
Star Rating
(584)4.5 out of 5
Market Segments
Enterprise (47.0% 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 allows for efficient storage and retrieval of large datasets. In contrast, Snowflake shines with a higher score of 8.8, indicating a more robust approach to data compression that enhances performance during data retrieval.
- Reviewers mention that Snowflake's cloud deployment is rated at 9.2, reflecting its seamless scalability and ease of use in cloud environments. Amazon Redshift, while also strong with a score of 8.9, is noted for its on-premise deployment capabilities, scoring 8.1, which may appeal to enterprises with specific infrastructure needs.
- G2 users highlight that Snowflake's data lake integration is superior, scoring 8.8 compared to Amazon Redshift's 8.6. This feature allows users to easily manage and analyze data across various sources, making it a preferred choice for organizations leveraging data lakes.
- Users on G2 report that Amazon Redshift's query language is highly rated at 9.3, providing a powerful tool for complex data analysis. However, Snowflake's overall performance in real-time analytics is rated at 9.1, showcasing its strength in handling live data queries effectively.
- Reviewers mention that Snowflake's auto recovery feature, rated at 9.2, provides a significant advantage in maintaining data integrity and availability. In comparison, Amazon Redshift's score of 8.2 in this area indicates room for improvement in its recovery processes.
- Users say that Snowflake's user access control is rated at 9.0, which enhances security and governance, making it easier for organizations to manage user permissions. Amazon Redshift, with a score of 8.7, also offers robust security features but may not be as intuitive as Snowflake's approach.
Featured Products
Sponsored
Squirro
(8)
Data Warehouse
Visit Website
Sponsored
InsertChat
(3)
Data Warehouse
Visit Website
Sponsored
WarpStream
(0)
Data Warehouse
Visit Website
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
280
9.1
427
Ease of Use
8.7
281
9.0
461
Ease of Setup
8.6
135
8.8
248
Ease of Admin
8.5
130
8.6
188
Quality of Support
8.5
263
8.6
386
Has the product been a good partner in doing business?
8.7
129
9.0
189
Product Direction (% positive)
8.9
253
9.1
398
Features by Category
Deployment
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
Deployment
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
Management
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Operations
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Management
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Generative AI
Not enough data
Not enough data
Not enough data
Not enough data
Data Science and Machine Learning PlatformsHide 27 FeaturesShow 27 Features
Not enough data
Not enough data
System
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Model Development
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Model Development
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Machine/Deep Learning Services
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Machine/Deep Learning Services
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Deployment
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Deployment
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Generative AI
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Data Management
8.8
129
|
Verified
8.9
124
|
Verified
8.4
121
|
Verified
8.8
110
|
Verified
8.8
127
|
Verified
8.9
120
|
Verified
8.1
123
|
Verified
8.1
113
|
Verified
7.7
98
|
Verified
8.0
95
|
Verified
8.3
114
|
Verified
8.6
99
|
Verified
Integration
7.9
97
|
Verified
8.0
88
|
Verified
8.6
124
|
Verified
8.7
114
|
Verified
8.6
115
|
Verified
8.8
105
|
Verified
Deployment
8.1
98
7.5
87
|
Verified
8.9
126
|
Verified
9.2
118
|
Verified
Performance
8.9
130
|
Verified
9.2
120
|
Verified
Security
8.7
122
|
Verified
8.7
111
|
Verified
8.8
124
|
Verified
9.0
122
|
Verified
Generative AI
Feature Not Available
Feature Not Available
Feature Not Available
Feature Not Available
Management
Not enough data
8.8
56
Not enough data
9.0
56
Not enough data
9.3
61
Not enough data
8.7
59
Not enough data
8.9
60
Maintenance
Not enough data
9.2
58
Not enough data
8.8
57
Not enough data
9.3
58
Security
Not enough data
9.1
58
Not enough data
9.1
60
Storage
8.4
50
9.1
37
8.4
53
9.1
36
Availability
8.7
44
9.0
32
8.2
47
9.2
30
8.4
45
9.1
34
Performance
8.3
45
9.2
36
Security
8.7
44
9.0
36
8.5
49
9.2
37
8.1
44
8.9
30
8.6
45
9.1
31
Support
8.1
40
9.3
29
8.4
44
9.0
28
Centralized computation
Not enough data
8.9
14
Localized computation
Not enough data
8.6
14
Data
Not enough data
Not enough data
Not enough data
Not enough data
Interaction
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
Learning
Not enough data
Not enough data
Not enough data
Not enough data
Content Generation
Not enough data
Not enough data
Not enough data
Not enough data
System
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Database
Not enough data
8.7
70
Not enough data
9.2
73
Not enough data
9.3
68
Integrations
Not enough data
8.5
51
Not enough data
8.7
55
Platform
Not enough data
9.0
64
Not enough data
9.0
70
Not enough data
8.7
55
Processing
Not enough data
9.2
68
Not enough data
9.0
67
Data Transformation
Not enough data
9.1
44
Not enough data
9.0
44
Connectivity
Not enough data
8.0
39
Not enough data
8.4
39
Not enough data
8.8
39
Not enough data
8.8
41
Operations
Not enough data
7.9
43
Not enough data
8.8
40
Not enough data
8.6
37
Not enough data
8.3
40
Not enough data
8.3
37
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 AI Chatbots, 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.1%
Computer Software
12.4%
Financial Services
8.0%
Retail
5.2%
Telecommunications
4.7%
Other
54.7%
Computer Software
13.6%
Information Technology and Services
12.9%
Financial Services
10.8%
Hospital & Health Care
4.3%
Marketing and Advertising
3.9%
Other
54.5%
Most Helpful Reviews
Amazon Redshift
Most Helpful Favorable Review
Mehdi C.
Verified User in Computer Software
It is fast, we can use it concurrently and we can use SQL over it so we don't have to learn a new language. The Redshift dashboard allow us to cancel request that take too much ressources. We can optimize to allow the request to run faster (with indexing)...
Most Helpful Critical Review
Verified User in Computer Software
It's only on AWS. That's why I can't really recommend this product unless you know you're going to stay on AWS forever. It really offers no differentiation from any other noSQL store and in fact has less features and reliability over most of the tried and...
Snowflake
Most Helpful Favorable Review
Rijul S.
Verified User in Food Production
Ease of usage Fast in memory querying Fast query response Seamless integration with dbt [data build tool] Easy to learn and understand Easy to implement with existing data engineering pipelines and solutions Support is very fast and effective can be...
Most Helpful Critical Review
Verified User in Internet
My main disappointment was with their support. We had an issue as soon as we signed a contract and it was about billing which seemed to be pushed off with no urgency and still not completed. Something like this I would have expected to be resolved within...
Mehdi C.
Verified User in Computer Software
It is fast, we can use it concurrently and we can use SQL over it so we don't have to learn a new language. The Redshift dashboard allow us to cancel request that take too much ressources. We can optimize to allow the request to run faster (with indexing)...
Rijul S.
Verified User in Food Production
Ease of usage Fast in memory querying Fast query response Seamless integration with dbt [data build tool] Easy to learn and understand Easy to implement with existing data engineering pipelines and solutions Support is very fast and effective can be...
Verified User in Computer Software
It's only on AWS. That's why I can't really recommend this product unless you know you're going to stay on AWS forever. It really offers no differentiation from any other noSQL store and in fact has less features and reliability over most of the tried and...
Verified User in Internet
My main disappointment was with their support. We had an issue as soon as we signed a contract and it was about billing which seemed to be pushed off with no urgency and still not completed. Something like this I would have expected to be resolved within...
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
You might get a relevant answer from it.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
I am unable to access external content such as the link you provided. However, if you have any specific text or content from the link that you would like...Read more
Hunting for software insights?
With over 2.5 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.
or continue with
Gmail.com addresses not permitted. A business domain using Google is allowed.
By proceeding, you agree to our Terms of Use and Privacy Policy
