Last updated on
Company health
Ratings
ClickHouse description
ClickHouse is a database management system specifically designed for analyzing very large amounts of data quickly. It achieves its speed by storing data in columns rather than rows. This makes it especially good for generating reports from data like business transactions, website activity, or application performance logs. ClickHouse is open-source and can be used for free, or as a paid cloud service with additional features.
Who is ClickHouse best for
ClickHouse is a column-oriented database management system (DBMS) designed for high-performance analytics. It excels at processing massive datasets quickly, making it ideal for real-time reporting and analysis. ClickHouse supports standard SQL and integrates with various data sources.
-
Best for medium to large businesses needing real-time data analysis (100+ employees).
-
Suitable for various data-heavy industries such as software, finance, and e-commerce.
ClickHouse features
| Supported ClickHouse supports standard SQL syntax with minor limitations such as lack of correlated subqueries. |
| Supported ClickHouse is a columnar database optimized for efficient queries and analysis, including time-series data. |
| Supported ClickHouse offers superior data compression with customizable algorithms like ZSTD and LZ4. |
| Supported ClickHouse supports real-time analytics due to fast query performance and high-volume data ingestion. |
| Supported ClickHouse supports integration with various data sources and real-time analytics for data-driven decisions. |
| Supported ClickHouse provides robust analytics and reporting tools for insights into revenue, customer behavior, and other KPIs. |
ClickHouse pricing
The commentary is based on 1 reviews from ClickHouse G2 reviews.
ClickHouse is praised for its cost-effectiveness, with users highlighting its ability to handle massive datasets on inexpensive hardware. One reviewer even mentioned running projects for around $100. While specific pricing details aren't available in reviews, the overall sentiment points to ClickHouse as a budget-friendly option.
See the ClickHouse pricing page.
-
ClickHouse has a free trial.
Basic
Up to 1 TB storage, 8-12 GiB total memory, Backups every 24h, retained for 1 day, 1 availability zone, Expert support with 1 business day response time
Scale
Unlimited storage, Configurable memory, Compute-compute separation, Backups every 24h, retained for 1 day, Configurable backups, 2+ availability zones, Expert support with 1 hour response time 24x7 for Severity 1 issues, S3 role-based access, Private networking, Automatic vertical scaling, Manual horizontal scaling
Enterprise
Everything in Scale, plus: SAML Single sign-on authentication (SSO), Private regions, Custom hardware profiles (HighMemory and HighCPU), Manual vertical scaling for custom profiles, Export backups to your own cloud account, Enterprise support with 30 min response time for Severity 1 issues, Transparent data encryption / CMEK, Scheduled upgrades, Consultative migrations guides, HIPAA compliance
ClickHouse alternatives
Google Cloud BigQueryBetter for established companies needing a fully managed, serverless data warehouse. Easier to use but with potentially higher and less predictable costs. Stronger Google Cloud Platform integration. A popular ClickHouse competitor.Read more
clickhouse vs SnowflakeBetter for established companies with greater data management and analysis needs. A broader industry fit, especially in software and IT. Has slower momentum. Users appreciate scalability and UI but find the new UI confusing and machine learning features lacking.Read more
PostgreSQLBetter for traditional relational database workloads. Open-source, with strong community support. Not optimized for analytical queries on very large datasets.Read more
Amazon RedshiftBetter fit for medium-sized businesses. Has broader industry applicability. Offers more user reviews providing valuable insights into its strengths and weaknesses. ClickHouse alternative; Amazon Redshift competitor.Read more
Deep.BIBetter for real-time data analysis and building custom data pipelines. Deep.BI is growing slower and focuses on enterprise-level clients with custom solutions using Apache Druid.Read more
StarTreeMore focused on real-time analytics and applications requiring sub-second query response times. G2 and Glassdoor ratings available, with user reviews highlighting performance while noting some stability and documentation concerns. Pricing model includes a free tier and paid options. Has slower momentum compared to ClickHouse.Read more
ClickHouse FAQ
What is ClickHouse and what does ClickHouse do?
ClickHouse is an open-source, column-oriented database management system designed for online analytical processing (OLAP) of high-volume data. Its columnar storage and data compression enable fast query execution, making it ideal for real-time analytics and reporting on massive datasets. It's available as free software and as a paid cloud service.
How does ClickHouse integrate with other tools?
ClickHouse integrates with various data sources and processing tools. It supports standard SQL and offers real-time analytics capabilities for seamless integration with existing data pipelines. This allows for efficient data analysis and reporting within the ClickHouse ecosystem.
What the main competitors of ClickHouse?
ClickHouse competes with other analytical databases like Google BigQuery, Snowflake, Amazon Redshift, and StarTree. It also faces competition from more general-purpose databases like PostgreSQL, particularly for smaller-scale analytical workloads. Deep.BI offers similar services focused on open-source tools.
Is ClickHouse legit?
ClickHouse is a legitimate and safe open-source database management system. It's known for its speed and efficiency in analyzing large datasets, making it a reliable choice for various analytical tasks. ClickHouse offers both free and paid versions with cloud support.
How much does ClickHouse cost?
ClickHouse pricing starts at $25.3 for all plans. They offer a 30-day free trial but no free plan. Paid plans include Basic for testing, Scale for production, and Enterprise for large-scale data, each with increasing features and support. Is ClickHouse worth it? It depends on your specific needs and budget.
Is ClickHouse customer service good?
There is no information available about ClickHouse's customer service.
Reviewed by
Michal has worked at startups for many years and writes about topics relating to software selection and IT management. As a former consultant for Bain, a business advisory company, he also knows how to understand needs of any business and find solutions to its problems.
Tymon is a seasoned CTO who loves finding the perfect tools for any task. He recently headed up the tech department at Batmaid, a well-known Swiss company, where he managed about 60 software purchases, including CX, HR, Payroll, Marketing automation and various developer tools.