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 offers a cloud service with three tiers: Basic, Scale, and Enterprise. A 30-day free trial is available. ClickPipes rates are $0.04 / GB for ingested data and $0.20 / hr per compute unit. ClickHouse also offers a bring your own cloud option and a forever-free open-source distribution.
See the ClickHouse pricing page.
-
ClickHouse has a free plan.
-
ClickHouse has a free trial.
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
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
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, Named Lead Support Engineer, Transparent data encryption / CMEK, Scheduled upgrades, Consultative migrations guides, HIPAA compliance
ClickHouse alternatives
clickhouse vs SnowflakeCloud data platform. Scales effortlessly. Simplifies data warehousing.Read more
ClickHouse FAQ
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
There is no information available about ClickHouse's customer service.
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.
An AI tool that observes your work, finds inefficiencies, and suggests smarter ways to do things. Maybe you can use your tools better, automate tasks, or switch software.