Introducing G2.ai, the future of software buying.Try now
Compare Amazon Redshift and Snowflake 
Featured Products
At a Glance
Market Segments
Mid-Market (39.5% of reviews)
Enterprise (44.8% 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)
Pros & Cons
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plansSnowflake
Star Rating
(678)4.6 out of 5
Market Segments
Enterprise (44.8% 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
281
9.1
514
Ease of Use
8.7
281
9.0
550
Ease of Setup
8.6
138
8.9
335
Ease of Admin
8.4
128
8.6
209
Quality of Support
8.5
264
8.7
470
Has the product been a good partner in doing business?
8.7
127
9.0
210
Product Direction (% positive)
8.8
252
9.2
484
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
29
Not enough data
9.0
27
Not enough data
9.3
28
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
185
|
Verified
8.4
125
|
Verified
8.9
172
|
Verified
8.8
131
|
Verified
9.0
178
|
Verified
8.0
127
|
Verified
8.3
173
|
Verified
7.6
102
|
Verified
8.2
152
|
Verified
8.3
118
|
Verified
8.7
156
|
Verified
Integration
7.9
101
|
Verified
8.2
143
|
Verified
8.7
128
|
Verified
8.9
174
|
Verified
8.6
119
|
Verified
8.9
161
|
Verified
Deployment
8.1
102
7.7
142
|
Verified
8.9
130
|
Verified
9.3
182
|
Verified
Performance
8.9
134
|
Verified
9.2
186
|
Verified
Security
8.7
126
|
Verified
8.9
171
|
Verified
8.8
128
|
Verified
9.1
180
|
Verified
Generative AI
7.3
20
7.9
80
7.2
19
8.1
81
Management
Not enough data
8.9
84
Not enough data
9.1
84
Not enough data
9.4
90
Not enough data
9.0
87
Not enough data
9.1
89
Maintenance
Not enough data
9.3
87
Not enough data
9.0
85
Not enough data
9.3
87
Security
Not enough data
9.2
86
Not enough data
9.3
89
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
98
Not enough data
9.3
101
Not enough data
9.3
95
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
96
Not enough data
9.1
94
Data Transformation
Not enough data
9.2
87
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
76
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
14.7%
Computer Software
12.8%
Financial Services
10.4%
Marketing and Advertising
4.6%
Hospital & Health Care
3.7%
Other
53.8%
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 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
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.
