Introducing G2.ai, the future of software buying.Try now
Compare Amazon Redshift and ClickHouse 
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.
ER/Studio
Visit Website
At a Glance
Market Segments
Mid-Market (39.5% of reviews)
Small-Business (47.4% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
Starting at $1.00 Per Month
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 plansClickHouse
Star Rating
(20)4.4 out of 5
Market Segments
Small-Business (47.4% of reviews)
Pros & Cons
Entry-Level Pricing
Starting at $1.00 Per Month
Learn more about ClickHouseSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Amazon Redshift excels in data integration with a score of 8.8, making it a preferred choice for enterprises needing to connect various data sources seamlessly. In contrast, ClickHouse, while strong in data modeling with a score of 9.0, does not match Redshift's integration capabilities.
- Reviewers mention that Redshift's performance analysis is top-notch, scoring a perfect 10.0, which indicates its ability to handle complex queries efficiently. ClickHouse, while also performing well, scores slightly lower in integrated cache performance at 7.7, suggesting it may not optimize query performance as effectively as Redshift.
- G2 users highlight that Redshift's ease of setup is rated at 8.6, which is beneficial for teams looking to get started quickly. Conversely, ClickHouse has a higher ease of setup score at 8.9, indicating that it may be more user-friendly for initial deployment.
- Users on G2 report that Redshift's built-in data analytics feature scores 8.1, which is useful for enterprises looking to derive insights directly from their data warehouse. ClickHouse, however, does not have a comparable built-in analytics feature, which may limit its utility for users focused on immediate data insights.
- Reviewers mention that Redshift's data security features, including role-based authorization and encryption, score 8.7 and 8.6 respectively, making it a strong contender for organizations prioritizing data governance. ClickHouse also performs well in security but does not have the same level of user access control features, which could be a drawback for some users.
- Users say that Redshift's scalability is rated at 8.9, making it suitable for growing enterprises that anticipate increased data loads. ClickHouse also scores well in scalability at 9.0, but users report that Redshift's performance under heavy workloads is more reliable, particularly in multi-user environments.
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%
ClickHouse
ClickHouse Pricing
Starting at $1.00
Per Month
Options for every user, organization, and use case.
- Up to 1 TB storage
- 16 GiB total memory
- Burstable CPU
Free Trial
Amazon Redshift
Free Trial is available
ClickHouse
No trial information availableRatings
Meets Requirements
8.7
281
8.9
11
Ease of Use
8.7
281
8.6
11
Ease of Setup
8.6
138
9.0
7
Ease of Admin
8.4
128
7.0
5
Quality of Support
8.5
264
8.7
9
Has the product been a good partner in doing business?
8.7
127
Not enough data
Product Direction (% positive)
8.8
252
10.0
10
Features by Category
Data Management
8.8
133
|
Verified
Not enough data
8.4
125
|
Verified
Not enough data
8.8
131
|
Verified
Not enough data
8.0
127
|
Verified
Not enough data
7.6
102
|
Verified
Not enough data
8.3
118
|
Verified
Not enough data
Integration
7.9
101
|
Verified
Not enough data
8.7
128
|
Verified
Not enough data
8.6
119
|
Verified
Not enough data
Deployment
8.1
102
Not enough data
8.9
130
|
Verified
Not enough data
Performance
8.9
134
|
Verified
Not enough data
Security
8.7
126
|
Verified
Not enough data
8.8
128
|
Verified
Not enough data
Generative AI
7.3
20
Not enough data
7.2
19
Not enough data
Management
Not enough data
9.4
6
Not enough data
7.9
7
Not enough data
9.3
7
Not enough data
9.4
6
Not enough data
10.0
5
Maintenance
Not enough data
8.8
7
Not enough data
7.8
6
Not enough data
Not enough data
Security
Not enough data
Not enough data
Not enough data
Not enough data
Management
Not enough data
Not enough data
Not enough data
9.3
5
Not enough data
Feature Not Available
Not enough data
Not enough data
Support
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
Feature Not Available
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Performance
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
Database Features
Not enough data
9.0
5
Not enough data
9.3
5
Not enough data
9.0
5
Not enough data
9.0
5
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
8.7
5
Storage
8.4
53
9.2
6
8.4
56
9.0
7
Availability
8.6
47
Feature Not Available
8.2
50
7.8
6
8.4
48
8.3
6
Performance
8.2
48
8.1
6
Security
8.7
47
9.0
5
8.4
52
Not enough data
8.1
47
Not enough data
8.5
48
8.3
5
Support
7.9
43
Not enough data
8.5
47
Not enough data
Query latency
Not enough data
Not enough data
Not enough data
Not enough data
Data latency
Not enough data
Not enough data
Not enough data
Not enough data
Connectors
Not enough data
Not enough data
Not enough data
Not enough data
Scale
Not enough data
Not enough data
Not enough data
Not enough data
Architecture
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Amazon Redshift and ClickHouse are categorized as Columnar Databases
Unique Categories
Amazon Redshift is categorized as Data Warehouse and Big Data Integration Platforms
ClickHouse is categorized as Real-time Analytic Database, Database Management Systems (DBMS), and Relational Databases
Reviews
Reviewers' Company Size
Amazon Redshift
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
ClickHouse
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
31.6%
Computer Software
21.1%
Wholesale
5.3%
Telecommunications
5.3%
Marketing and Advertising
5.3%
Other
31.6%
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
ClickHouse has no discussions with answers
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.
