Compare Amazon Redshift and Snowflake 
Featured Products
At a Glance
Market Segments
Mid-Market (40.0% of reviews)
Mid-Market (44.2% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
$2 Compute/Hour
Amazon Redshift
Star Rating
(400)4.3 out of 5
Market Segments
Mid-Market (40.0% of reviews)
Pros & Cons
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plansSnowflake
Star Rating
(729)4.6 out of 5
Market Segments
Mid-Market (44.2% of reviews)
Pros & Cons
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.
- G2 reviewers report that Snowflake excels in user experience, with many users appreciating its simple and fast approach to advanced data warehousing. One user highlighted how it allows for easy implementation of SQL queries, making it a favorite for those who prioritize usability.
- Users say Amazon Redshift shines in scalability, with recent feedback noting its ability to store and analyze large amounts of data quickly. This feature is particularly beneficial for businesses looking for a cost-effective solution compared to traditional data warehousing options.
- Reviewers mention that Snowflake's architecture is designed for the cloud, which simplifies the process of managing data without heavy infrastructure work. This aspect has been praised for its result-oriented capabilities, making it a strong choice for enterprises.
- According to verified reviews, Amazon Redshift offers a powerful column-based data solution that enhances query performance. Users have noted its effectiveness in cross-database analytics, which can be a game-changer for organizations needing to integrate diverse data sources.
- G2 reviewers highlight that Snowflake provides a more intuitive framework, with a user-friendly layout that makes navigating the platform easier. This has been particularly appreciated by users who are new to data warehousing and seek a straightforward experience.
- Users report that while Amazon Redshift is easy to set up and scale, it may face challenges in meeting specific workflow needs for some users. However, features like multi-zone architecture and easy log access have been noted as significant advantages for those who prioritize operational efficiency.
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
284
9.1
558
Ease of Use
8.7
284
9.0
595
Ease of Setup
8.6
141
8.9
379
Ease of Admin
8.4
129
8.6
211
Quality of Support
8.5
267
8.7
511
Has the product been a good partner in doing business?
8.7
128
9.0
213
Product Direction (% positive)
8.9
255
9.2
527
Features by Category
Administration
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
Not enough data
Not enough data
Compliance
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Security
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Data Quality
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Maintainence
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
Agentic AI - Data Governance
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
Deployment
Not enough data
9.2
13
Not enough data
9.0
13
Not enough data
9.1
13
Not enough data
9.4
13
Not enough data
9.4
13
Deployment
Not enough data
9.4
11
Not enough data
9.5
11
Not enough data
9.5
11
Not enough data
9.5
11
Not enough data
9.4
11
Management
Not enough data
9.0
13
Not enough data
9.0
12
Not enough data
9.2
13
Not enough data
9.1
13
Operations
Not enough data
8.9
11
Not enough data
8.9
11
Not enough data
9.5
11
Management
Not enough data
9.2
11
Not enough data
9.3
10
Not enough data
8.8
11
Generative AI
Not enough data
8.6
11
Not enough data
8.5
11
System
Not enough data
9.2
30
Model Development
Not enough data
9.1
31
Not enough data
8.6
29
Not enough data
8.3
29
Not enough data
8.8
30
Model Development
Not enough data
8.8
28
Machine/Deep Learning Services
Not enough data
8.6
29
Not enough data
8.6
29
Not enough data
8.4
29
Not enough data
8.4
28
Machine/Deep Learning Services
Not enough data
8.6
28
Not enough data
8.5
25
Deployment
Not enough data
9.1
31
Not enough data
9.0
28
Not enough data
9.2
30
Generative AI
Not enough data
8.5
27
Not enough data
8.4
26
Not enough data
8.5
26
Agentic AI - Data Science and Machine Learning Platforms
Not enough data
8.3
14
Not enough data
8.3
14
Not enough data
8.5
14
Not enough data
8.6
14
Not enough data
8.3
14
Not enough data
8.4
15
Not enough data
8.3
14
Data Management
8.8
135
|
Verified
9.1
211
|
Verified
8.4
125
|
Verified
8.9
178
|
Verified
8.8
131
|
Verified
9.1
188
|
Verified
8.0
127
|
Verified
8.4
186
|
Verified
7.6
102
|
Verified
8.3
163
|
Verified
8.3
119
|
Verified
8.8
168
|
Verified
Integration
7.9
101
|
Verified
8.4
159
|
Verified
8.7
129
|
Verified
9.0
199
|
Verified
8.6
119
|
Verified
8.9
172
|
Verified
Deployment
8.1
102
7.8
148
|
Verified
8.9
131
|
Verified
9.3
205
|
Verified
Performance
8.9
136
|
Verified
9.3
216
|
Verified
Security
8.7
126
|
Verified
8.9
187
|
Verified
8.8
128
|
Verified
9.1
196
|
Verified
Generative AI
7.3
20
8.1
84
7.2
19
8.1
83
Management
Not enough data
9.0
86
Not enough data
9.1
86
Not enough data
9.4
92
Not enough data
9.0
91
Not enough data
9.1
90
Maintenance
Not enough data
9.3
88
Not enough data
9.0
88
Not enough data
9.3
90
Security
Not enough data
9.3
88
Not enough data
9.3
91
Storage
8.4
53
9.2
45
8.4
56
9.2
45
Availability
8.6
47
9.1
40
8.2
50
9.2
38
8.4
48
9.2
42
Performance
8.2
48
9.2
45
Security
8.7
47
9.1
45
8.4
52
9.2
46
8.1
47
8.9
39
8.5
48
9.2
39
Support
7.9
43
9.2
37
8.5
47
9.2
36
Centralized computation
Not enough data
9.3
26
Localized computation
Not enough data
9.1
25
Database
Not enough data
9.0
100
Not enough data
9.3
103
Not enough data
9.3
97
Integrations
Not enough data
8.7
78
Not enough data
8.7
83
Platform
Not enough data
9.1
94
Not enough data
9.0
99
Not enough data
8.7
83
Processing
Not enough data
9.3
99
Not enough data
9.1
97
Data Transformation
Not enough data
9.2
90
Not enough data
9.4
92
Connectivity
Not enough data
8.6
80
Not enough data
8.7
81
Not enough data
9.1
84
Not enough data
9.1
84
Operations
Not enough data
8.6
88
Not enough data
9.2
82
Not enough data
8.9
77
Not enough data
8.8
82
Not enough data
8.8
81
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, Data Science and Machine Learning Platforms, Database Management Systems (DBMS), and Data Governance
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.3%
Computer Software
12.6%
Financial Services
7.7%
Retail
5.2%
Marketing and Advertising
4.7%
Other
54.5%
Information Technology and Services
15.2%
Computer Software
14.1%
Financial Services
9.7%
Marketing and Advertising
4.5%
Hospital & Health Care
3.4%
Other
53.1%
Alternatives
Discussions
When can I use Amazon redshift?
3 Comments
VK
You can use it in Datawarehousing. Read more
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
What are the characteristics of redshift?
2 Comments
AK
Redshift is mainly used for Big data and analytics to store the data in columner format. Retrieve the data is very fast and parallel processing also most...Read 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.
Your software and services insights are valuable.
Your peers come to G2 to get an inside look at and other business solutions. Adding perspective on will help others pick the right solution based on real user experience.
