Get a recommendation
Tell us your requirements and our advisors will help you compare and shortlist the best-fit options, free and unbiased.
A real human, fast
Someone on our team replies within one business day, no bots, no ticket queue.
Routed to the right team
Buying, selling, partnering, or investing, you reach the people who can actually help.
Independent & unbiased
No pushy sales. Just honest guidance grounded in the ecosystem.
Tailored to your context
Tell us what you need and we shape the next steps around it.
Who are you? Pick the option that fits best.
Open-source columnar database and cloud for real-time analytics
Updated
ClickHouse is an open-source, column-oriented database management system for real-time analytics on large datasets using SQL. It is available as a free self-hosted server under the Apache 2.0 license and as ClickHouse Cloud, a managed service on AWS, Google Cloud and Azure.
Teams load data into ClickHouse through ClickPipes or their own pipelines and query it with SQL. In ClickHouse Cloud, compute is billed per compute-unit-hour, where one unit is 8 GiB of RAM and 2 vCPU, and storage per terabyte per month. Idle services scale to zero, and backups, data transfer and ClickPipes are metered separately.
ClickHouse is used by engineering and data teams for observability, product analytics and AI workloads. The vendor names customers including Sony, Lyft, Cisco, GitLab and Tesla, and says over 100,000 developers use it.
The open-source server is free. ClickHouse Cloud has Basic, Scale and Enterprise plans priced by usage, with prices varying by cloud provider and region. Example rates on AWS us-east-1 per compute-unit-hour are $0.21811 for Basic, $0.29846 for Scale and $0.39030 for Enterprise, with storage at $25.30 per terabyte per month. A 30-day trial includes $300 in credits with no credit card, after which the account moves to pay as you go.
The vendor says ClickHouse has over 100 integrations, including BI tools, language clients, data lakes and object storage, and names ClickPipes for ingestion and Docker for installation.
Google BigQuery is a serverless data warehouse billed by query or slot. Snowflake and Databricks are cloud data platforms with broader data engineering and AI features. Firebolt is a cloud warehouse also aimed at fast analytics. ClickHouse differs by being open source and available self-hosted as well as managed.
Pricing Model
USAGE BASED
Starting Price
Contact vendor
Free Options
Free version, Free trial
| Feature | Basic | Scale | Enterprise |
|---|---|---|---|
| Up to 1 TB storage | , | , | |
| 8 to 12 GiB memory | , | , | |
| Usage-based, from $0.21811 per compute-unit-hour (AWS us-east-1) | , | , | |
| Unlimited storage | , | , | |
| Compute-compute separation | , | , | |
| Private networking | , | , | |
| From $0.29846 per compute-unit-hour | , | , | |
| SAML SSO | , | , | |
| Customer-managed encryption | , | , | |
| HIPAA and PCI compliance | , | , | |
| From $0.39030 per compute-unit-hour | , | , |
API Types
SDK Availability
Verify SDK availability in vendor's documentation.
Developer Features
No reviews yet. Be the first to review ClickHouse.
Have a question about ClickHouse? Ask the community.
Compliance Standards
SOC 2 Type II
EnterpriseISO 27001
EnterpriseGDPR Compliant
GlobalHIPAA
HealthcarePCI DSS
FinanceCCPA
PrivacyFedRAMP
GovernmentCSA STAR
CloudDeployment & Data
Data Residency Options
Verify with vendor for your specific region requirements.
Fully managed cloud data platform for warehousing and analytics
Serverless data warehouse with SQL, BigQuery ML and open table formats
Data intelligence platform (lakehouse) for analytics and AI
Quick comparisons