Amazon Redshift vs ClickHouse Cloud
Amazon Redshift
aws.amazon.com
ClickHouse Cloud
clickhouse.comSide by side
| Figure | Amazon Redshift | ClickHouse Cloud |
|---|---|---|
| Price from | $0.54/mo | $25.30/mo |
| Free plan | — | — |
| Free trial | Yes | Yes |
| Open source | — | Yes |
| Web | Yes | Yes |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| API | Yes | Yes |
| Self-hosted | — | Yes |
| Plans published | 4 | 3 |
| Spec score · Cloud Analytics Solutions | 8.3 (#6) | 9.2 (#2) |
| Spec score · OLAP Software | 8.3 (#8) | 9.1 (#1) |
| Spec score · Columnar Databases | 8.3 (#7) | 9.1 (#4) |
| Spec score · OLAP Databases | 8.2 (#8) | 9.0 (#4) |
| Spec score · Analytical Data Store Software | 8.2 (#8) | 9.1 (#2) |
| Spec score · Analytics Databases | 8.3 (#9) | 9.1 (#2) |
| Spec score · Analytics Data | 8.3 (#9) | 9.1 (#2) |
| Spec score · Database Software | 8.1 (#43) | 9.0 (#8) |
| Free plan | No | No |
| Intended workloads | AWS describes use cases including dashboarding, application development, data sharing, and ETL jobs. | The pricing page describes Basic for testing and starter projects, Scale for production and data at scale, and Enterprise for very large or enterprise use cases. |
| Security | Redshift supports encryption in transit and at rest, row- and column-level access controls, and dynamic data masking. | The Cloud page lists access controls, encryption in transit and at rest, activity logging, and SOC 2 Type II compliance. |
| What it does | Amazon Redshift is a cloud data warehouse for SQL analytics across data warehouses and data lakes. | ClickHouse Cloud is a fully managed service for real-time analytics, observability and AI data applications. |
Plans
Amazon Redshift
- Provisioned$0.54 a month
- Serverless$1.50 a month
- Provisioned on-demand$0.54 a month
- Redshift Serverless on-demand$1.50 a month
ClickHouse Cloud
- Basic$25.30 a month
- Enterprise$25.30 a month
- Scale$25.30 a month
In their own words
Amazon Redshift
Amazon Redshift is a cloud data warehouse for SQL analytics across data warehouses and data lakes. It offers provisioned and serverless deployments, with options AWS says can scale to petabytes and support thousands of concurrent users. Redshift runs read-only SQL queries on Apache Iceberg, Apache Hudi, and Delta Lake tables, plus open file formats in Amazon S3. Zero-ETL integrations connect with Amazon Aurora, Amazon RDS, Amazon DynamoDB, and enterprise applications. Streaming ingestion connects with Amazon Kinesis Data Streams and Amazon Managed Streaming for Apache Kafka. Listed integrations include QuickSight, Tableau, Microsoft Power BI, Alteryx, Jupyter Notebook, Informatica, dbt, MicroStrategy, and Looker. The Data API supports AWS SDK languages including Python, Go, Java, Node.js, PHP, Ruby, and C++. Security includes encryption, row- and column-level controls, and dynamic masking. It is paid, has no free plan, offers a free trial, and starts at $0.54 per month for Provisioned or $1.50 per month for Serverless.
ClickHouse Cloud
ClickHouse Cloud has no write-up on Specifiction yet; its figures are above.