ClickHouse review

ClickHouse is an open-source, column-oriented database for analytical queries on large datasets. It stores values from the same columns together, a design suited to scanning and aggregating data rather than serving every kind of application workload. The product is positioned for real-time analytics, observability, data warehousing, and ML and GenAI workloads.

You can run it as ClickHouse Cloud, self-managed ClickHouse, or ClickHouse Local. The Local tool can query files such as CSV, TSV, and Parquet without running a server, according to the product details. ClickHouse supports SQL, compression, and queries designed for millisecond-scale analysis; actual speed depends on the workload and setup, so we would not treat that as a blanket guarantee.

The practical distinction is deployment and operating work: Cloud is managed, while self-managed puts more responsibility on your team. Reddit users describe ClickHouse as fast and easy to run locally, but also note that self-hosting takes engineering support.

ClickHouse’s clearest fit is fast analytical SQL over large datasets. Columnar storage and compression are designed for that workload, and the product supports both local file queries and larger deployments. That gives teams a path from experimenting on CSV or Parquet files to running a managed cloud service or self-managed cluster, rather than requiring a cloud warehouse for every step.

Reddit users repeatedly cite query speed and local use as reasons to choose it. One commenter reports sub-second queries over more than 30 billion records, but that is an individual report, not a general performance promise. Other users describe using ClickHouse with Kafka streams and in local development or CI workflows.

The available Cloud plans also give buyers some room to choose operating characteristics:

• Basic lists compute at $0.2181 per unit-hour and storage at $25.30 per TB-month, with up to 1 TB of storage, 8–12 GiB of memory, one availability zone, and daily backups retained for one day.
• Scale lists compute at $0.2985 per unit-hour, the same storage rate, unlimited storage, configurable memory, and at least two availability zones.
• Enterprise lists compute at $0.3903 per unit-hour and adds a 30-minute Severity 1 support response, HIPAA, and PCI compliance.

Those are usage rates, not predictable monthly plan totals.

ClickHouse is not a low-effort replacement for every warehouse or database. Reddit users say it can need engineering support, and some report friction with updates, joins, data types, and null handling. Others say those areas have improved, so these are points to validate against your own schemas and query patterns rather than settled product limits. One commenter also flags a MySQL connector workaround for Looker Studio as a drawback for nontechnical users.

Cloud costs are usage-based, and the pricing page lists no fixed monthly totals or annual rates. Basic is capped at 1 TB of storage and one availability zone; its backups run every 24 hours and are kept for one day. Scale removes the storage cap and offers two or more zones, but compute and storage still accrue by usage. Public internet egress starts at $0.1152/GB, while inter-region egress starts at $0.0312/GB. ClickPipes rates vary by connector and are not listed here.

The Cloud trial is 30 days, and the pricing page lists no free Cloud plan. Self-managed and local use are separate options, but they shift more operating responsibility to your team. Choose ClickHouse for fast analytics if you can handle the engineering and variable cloud bill.

ClickHouse Cloud is usage-based, not a fixed monthly subscription. The pricing page lists monthly billing in USD, with no annual rates published. Basic compute costs $0.2181 per unit-hour and storage costs $25.30 per TB-month. Basic is capped at 1 TB of storage and 8–12 GiB of memory, with one availability zone.

Scale raises compute to $0.2985 per unit-hour—about 37% more than Basic—and includes unlimited storage, configurable memory, and at least two availability zones. Enterprise is $0.3903 per unit-hour, about 31% above Scale, and adds a 30-minute Severity 1 support response plus HIPAA and PCI compliance. Both higher tiers list storage at $25.30 per TB-month.

The bill can also include egress: public internet starts at $0.1152 per GB, and inter-region egress at $0.0312 per GB. ClickPipes rates vary by connector and are not listed. Managed Postgres is in beta; its advertised 50% discount has no published rate. A 30-day trial is available, but the pricing material does not give a monthly total. Budget for usage to vary.

Treat a move to ClickHouse as an engineering project, not a simple dashboard swap. It is a column-oriented database aimed at analytical queries on large datasets, so first check whether your schemas, SQL, and workload fit that use. The published material does not specify migration tools, compatibility details, or export steps; plan to validate those before committing.

ClickHouse Local can query CSV, TSV, and Parquet files without a server, which may help with file-based analysis. That does not establish a complete export path or make a migration automatic. Ask how you will move your data and queries back out, and confirm the costs of storage and egress: public internet egress starts at $0.1152 per GB, while inter-region egress starts at $0.0312 per GB.

The published material includes no Reddit posts or comments, so we cannot say what users there report as reasons for leaving. We also can’t confirm vendor lock-in or specific exit pain points from these sources. Teams that need frequent transactional updates or a predictable monthly bill should weigh those limits before switching.