ClickHouse

ClickHouse

5.0 out of 5 stars
Amazon Redshift ClickHouse

Related Products

  • Google Cloud BigQuery
    4.5 out of 5 stars 2,037 Ratings
    Visit Website for Google Cloud BigQuery
  • RaimaDB
    4.8 out of 5 stars 12 Ratings
    Visit Website for RaimaDB
  • Denodo
    4.6 out of 5 stars 388 Ratings
    Visit Website for Denodo
  • AnalyticsCreator
    4.6 out of 5 stars 46 Ratings
    Visit Website for AnalyticsCreator
  • Google Cloud Platform
    4.5 out of 5 stars 61,093 Ratings
    Visit Website for Google Cloud Platform
  • Google Cloud SQL
    4.5 out of 5 stars 554 Ratings
    Visit Website for Google Cloud SQL
  • SCIKIQ
    4.6 out of 5 stars 14 Ratings
    Visit Website for SCIKIQ
  • TIMi
    4.9 out of 5 stars 68 Ratings
    Visit Website for TIMi
  • DataBuck
    4.8 out of 5 stars 6 Ratings
    Visit Website for DataBuck
  • sellerboard
    4.7 out of 5 stars 316 Ratings
    Visit Website for sellerboard
Amazon Redshift:

About

Amazon Redshift is a cloud-based data warehouse solution from AWS designed to deliver high-performance analytics and support modern AI-driven workloads. The platform enables organizations to analyze large volumes of structured and unstructured data across data warehouses, data lakes, and third-party sources using SQL. Redshift is built for scalability and cost efficiency, offering improved throughput and price-performance with AWS Graviton-powered RG instances and Redshift Serverless options. The solution also supports near real-time analytics through zero-ETL integrations that connect operational databases, streaming services, and enterprise applications without complex data pipelines. Amazon Redshift integrates with Amazon SageMaker and Amazon Bedrock to support advanced machine learning, analytics, and generative AI use cases.
ClickHouse:

About

ClickHouse is a fast open-source OLAP database management system. It is column-oriented and allows to generate analytical reports using SQL queries in real-time. ClickHouse's performance exceeds comparable column-oriented database management systems currently available on the market. It processes hundreds of millions to more than a billion rows and tens of gigabytes of data per single server per second. ClickHouse uses all available hardware to its full potential to process each query as fast as possible. Peak processing performance for a single query stands at more than 2 terabytes per second (after decompression, only used columns). In distributed setup reads are automatically balanced among healthy replicas to avoid increasing latency. ClickHouse supports multi-master asynchronous replication and can be deployed across multiple datacenters. All nodes are equal, which allows avoiding having single points of failure.
Amazon Redshift:

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported
ClickHouse:

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported
Amazon Redshift:

Audience

Enterprises, data engineers, business intelligence teams, analytics professionals, developers, and organizations seeking scalable cloud data warehousing, real-time analytics, and AI-driven data processing capabilities
ClickHouse:

Audience

Companies of all sizes
Amazon Redshift:

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Supported
ClickHouse:

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Not Supported
Amazon Redshift:

API

Offers API Supported
ClickHouse:

API

Offers API Not Supported
Amazon Redshift:

Screenshots and Videos

ClickHouse:

Screenshots and Videos

Amazon Redshift:

Pricing

$0.543 per hour
Free Version Not Supported
Free Trial Supported
ClickHouse:

Pricing

No information available.
Free Version Supported
Free Trial Not Supported
Amazon Redshift:

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software
ClickHouse:

Reviews/Ratings

Overall 5.0 / 5
ease 3.0 / 5
features 4.0 / 5
design 5.0 / 5
support 5.0 / 5
ClickHouse:

Pros & Cons from Real Users

Pros

  • ClickHouse is really really fast. I can say that it is THE fastest I've came across. It has lots of native integration options S3, Kafka, SQLite, PostgreSQL and so on. Its SQL capabilities are top notch. And it is 100% free!

Cons

  • - Updates and deletes are eventual. - Hard to setup a cluster. - Does not have ACID.
Amazon Redshift:

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported
ClickHouse:

Training

Documentation Not Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported
Amazon Redshift:

Company Information

Amazon
Founded: 1994
United States
aws.amazon.com/redshift/
ClickHouse:

Company Information

ClickHouse
Founded: 2021
United States
clickhouse.com
Amazon Redshift:

Alternatives

Google Cloud BigQuery

Google Cloud BigQuery

Google
4.5 out of 5 stars
ClickHouse:

Alternatives

Amazon Redshift:
Snowflake

Snowflake

4.8 out of 5 stars
ClickHouse:
Amazon Redshift:
Teradata VantageCloud

Teradata VantageCloud

Teradata
5.0 out of 5 stars
ClickHouse:
Amazon Redshift:
Vertica

Vertica

Rocket Software
ClickHouse:
Amazon Redshift:
Azure Synapse Analytics

Azure Synapse Analytics

Microsoft
3.0 out of 5 stars
ClickHouse:
Amazon Redshift:

Categories

Agentic AI Supported
Big Data Supported
Columnar Databases Supported
Data Warehouse Supported
OLAP Databases Supported
SQL Databases Supported
ClickHouse:

Categories

Amazon Redshift:

Integrations

Airbyte Supported
Apache Superset Supported
BI Book Supported
DataGrip Supported
DataHub Supported
DbGate Supported
DbVisualizer Supported
Draxlr Supported
ElevateHQ Supported
GrowthBook Supported
Hue Supported
Manticore Search Supported
Nucleon Database Master Supported
Peaka Supported
Preset Supported
Querona Supported
RudderStack Supported
Toucan Supported
arcodash Supported
rakam Supported
ClickHouse:

Integrations

Airbyte Supported
Apache Superset Supported
BI Book Supported
DataGrip Supported
DataHub Supported
DbGate Supported
DbVisualizer Supported
Draxlr Supported
ElevateHQ Supported
GrowthBook Supported
Hue Supported
Manticore Search Supported
Nucleon Database Master Supported
Peaka Supported
Preset Supported
Querona Supported
RudderStack Supported
Toucan Supported
arcodash Supported
rakam Supported
Amazon Redshift:
Claim Amazon Redshift and update features and information
Claim Amazon Redshift and update features and information
ClickHouse:
Claim ClickHouse and update features and information
Claim ClickHouse and update features and information