G2 Vendor Directory

Amazon Redshift vs. ClickHouse

A side-by-side comparison based on G2 review data.

MetricAmazon Redshift

by Amazon Web Services (AWS)

ClickHouse

by ClickHouse

Overall rating4.34.3
Review count40456
Ease of use8.98.8
Ease of setup8.88.4
Quality of support8.78.4
Meets requirements8.99.1
NPS53.36927250.909091
Small Business20.6%44.6%
Mid-Market39.3%42.9%
Enterprise40.0%12.5%
Total page views511513
Total LLM citations5,9545,808

Amazon Redshift

Tens of thousands of customers use Amazon Redshift, a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools. It is optimized for datasets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions.

Pros

  • Integrations
  • Ease of Use
  • Fast Querying
  • Scalability
  • Easy Integrations
  • Performance

ClickHouse

ClickHouse is the fastest and most resource efficient real-time database and data warehouse. ClickHouse is optimized to serve a wide range of data-intensive workloads, from powering interactive user-facing dashboards to running ad-hoc historical analysis over petabytes of data. Today, ClickHouse Cloud is used by enterprises all over the world, including Lyft, Sony, IBM, GitLab, Twilio, HubSpot, and many more. ClickHouse is available open-source or through cloud services on AWS, GCP, and soon, Azure.

Pros

  • Query Speed
  • Speed
  • Easy Integrations
  • Integrations
  • Query Efficiency
  • Large Datasets