Compare Amazon Redshift and Snowflake

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
Amazon Redshift
Amazon Redshift
Star Rating
(400)4.3 out of 5
Market Segments
Enterprise (40.0% of reviews)
Information
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plans
Snowflake
Snowflake
Star Rating
(587)4.5 out of 5
Market Segments
Enterprise (47.1% of reviews)
Information
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 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.
Featured Products
Pricing
Entry-Level Pricing
Amazon Redshift
RA3.4xlarge
$1.22 - $3.26
Per hour
Browse all 6 pricing plans
Snowflake
Standard
$2
Compute/Hour
Browse all 4 pricing plans
Free Trial
Amazon Redshift
Free Trial is available
Snowflake
Free Trial is available
Ratings
Meets Requirements
8.7
281
9.1
430
Ease of Use
8.7
282
9.0
464
Ease of Setup
8.6
136
8.8
250
Ease of Admin
8.5
130
8.6
188
Quality of Support
8.5
264
8.6
389
Has the product been a good partner in doing business?
8.7
129
9.0
189
Product Direction (% positive)
8.9
254
9.1
401
Features by Category
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
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
8.7
5
Not enough data
7.7
5
Not enough data
6.3
5
Model Development
Not enough data
9.3
5
Not enough data
7.0
5
Not enough data
7.0
5
Not enough data
8.7
5
Model Development
Not enough data
6.7
5
Not enough data
7.7
5
Not enough data
8.7
5
Machine/Deep Learning Services
Not enough data
8.0
5
Not enough data
8.0
5
Not enough data
7.7
5
Not enough data
7.0
5
Machine/Deep Learning Services
Not enough data
8.0
5
Not enough data
7.3
5
Not enough data
6.7
5
Not enough data
Not enough data
Deployment
Not enough data
8.3
5
Not enough data
7.7
5
Not enough data
9.3
5
Deployment
Not enough data
7.3
5
Not enough data
8.0
5
Not enough data
7.7
5
Generative AI
Not enough data
7.3
5
Not enough data
7.3
5
Not enough data
8.0
5
8.5
142
8.6
147
Data Management
8.8
129
|
Verified
8.9
127
|
Verified
8.4
121
|
Verified
8.8
113
|
Verified
8.8
127
|
Verified
8.9
123
|
Verified
8.1
123
|
Verified
8.1
116
|
Verified
7.7
98
|
Verified
8.0
98
|
Verified
8.3
114
|
Verified
8.5
102
|
Verified
Integration
7.9
97
|
Verified
8.1
91
|
Verified
8.6
124
|
Verified
8.7
117
|
Verified
8.6
115
|
Verified
8.8
108
|
Verified
Deployment
8.1
98
7.4
90
|
Verified
8.9
126
|
Verified
9.2
121
|
Verified
Performance
8.9
130
|
Verified
9.2
123
|
Verified
Security
8.7
122
|
Verified
8.7
114
|
Verified
8.8
124
|
Verified
9.0
124
|
Verified
Generative AI
Feature Not Available
Feature Not Available
Feature Not Available
Feature Not Available
Database Management Systems (DBMS)Hide 10 FeaturesShow 10 Features
Not enough data
9.0
70
Management
Not enough data
8.8
57
Not enough data
9.0
57
Not enough data
9.3
62
Not enough data
8.7
60
Not enough data
8.9
61
Maintenance
Not enough data
9.2
59
Not enough data
8.8
58
Not enough data
9.3
59
Security
Not enough data
9.1
59
Not enough data
9.1
61
8.4
60
9.1
43
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
Not enough data
8.8
15
Centralized computation
Not enough data
8.9
14
Localized computation
Not enough data
8.6
14
Not enough data
Not enough data
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
Big Data Processing and DistributionHide 10 FeaturesShow 10 Features
Not enough data
8.9
85
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
Not enough data
8.6
48
Data Transformation
Not enough data
9.1
45
Not enough data
9.0
45
Connectivity
Not enough data
8.0
40
Not enough data
8.3
40
Not enough data
8.7
40
Not enough data
8.7
42
Operations
Not enough data
8.0
44
Not enough data
8.9
41
Not enough data
8.6
38
Not enough data
8.3
41
Not enough data
8.3
38
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
Amazon Redshift
Amazon Redshift
Snowflake
Snowflake
Amazon Redshift and Snowflake are categorized as Columnar Databases, Data Warehouse, and Big Data Integration Platforms
Reviews
Reviewers' Company Size
Amazon Redshift
Amazon Redshift
Small-Business(50 or fewer emp.)
21.6%
Mid-Market(51-1000 emp.)
38.4%
Enterprise(> 1000 emp.)
40.0%
Snowflake
Snowflake
Small-Business(50 or fewer emp.)
12.8%
Mid-Market(51-1000 emp.)
40.1%
Enterprise(> 1000 emp.)
47.1%
Reviewers' Industry
Amazon Redshift
Amazon Redshift
Information Technology and Services
15.3%
Computer Software
12.3%
Financial Services
7.9%
Retail
5.2%
Telecommunications
4.7%
Other
54.5%
Snowflake
Snowflake
Computer Software
13.7%
Information Technology and Services
12.8%
Financial Services
10.8%
Hospital & Health Care
4.3%
Marketing and Advertising
3.9%
Other
54.5%
Most Helpful Reviews
Amazon Redshift
Amazon Redshift
Most Helpful Favorable Review
VK
Vijay K.
Verified User in Accounting

Amazon Redshift is one of the best data warehouse platforms provided by AWS. It uses SQL to analyze structured, semi-structured, and unstructured data on the managed servers, so you don't have to worry about infrastructure and hardware maintenance.

Most Helpful Critical Review
Verified User
G
Verified User in Telecommunications

I find it harder to code of red shift databases than other products

Snowflake
Snowflake
Most Helpful Favorable Review
RS
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
G
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
Amazon Redshift
Amazon Redshift Alternatives
Google Cloud BigQuery
Google Cloud BigQuery
Add Google Cloud BigQuery
OpenText Vertica
OpenText Vertica
Add OpenText Vertica
Cloudera
Cloudera
Add Cloudera
IBM Db2
IBM Db2
Add IBM Db2
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
SAP HANA Cloud
SAP HANA Cloud
Add SAP HANA Cloud
Discussions
Amazon Redshift
Amazon Redshift 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
Is Amazon redshift good for large datasets considering its cost.
2 comments
AC
its costlyRead more
Snowflake
Snowflake Discussions
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
What is the difference between Snowflake vs Redshift? Which one is Good to Learn.
2 comments
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