- Home
- ...
- Real-time Analytic Database Software
- ClickHouse
- Google Cloud BigQuery
- ClickHouse-vs-Google Cloud BigQuery
Compare ClickHouse and Google Cloud BigQuery 
At a Glance
Market Segments
Small-Business (50.0% of reviews)
Enterprise (39.9% of reviews)
Entry-Level Pricing
Starting at $1.00 Per Month
Free
ClickHouse
Star Rating
(19)4.3 out of 5
Market Segments
Small-Business (50.0% of reviews)
Entry-Level Pricing
Starting at $1.00 Per Month
Learn more about ClickHouseGoogle Cloud BigQuery
Star Rating
(1,091)4.5 out of 5
Market Segments
Enterprise (39.9% of reviews)
Entry-Level Pricing
Free
Free Trial is available
Browse all 5 pricing plansSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Google Cloud BigQuery excels in its data integration capabilities, scoring 9.0, which allows seamless connections with various data sources, while ClickHouse, with a score of 8.6, is noted for its Hadoop integration but lacks the same breadth of options.
- Reviewers mention that Google Cloud BigQuery's query language is highly rated at 9.3, providing a user-friendly experience for complex queries, whereas ClickHouse, while also strong at 9.0, is sometimes seen as less intuitive for new users.
- G2 users highlight that Google Cloud BigQuery's performance analysis feature stands out with a perfect score of 10.0, enabling users to efficiently analyze large datasets, while ClickHouse, despite its robust performance, scores lower at 9.0, indicating room for improvement.
- Reviewers say that Google Cloud BigQuery's data security features, including encryption and role-based authorization, are highly rated at 9.1, providing peace of mind for enterprise users, while ClickHouse, with a score of 8.4, is perceived as having less comprehensive security measures.
- Users on G2 report that Google Cloud BigQuery's ease of setup is rated at 8.6, making it accessible for users with varying technical skills, while ClickHouse, with a higher score of 8.9, is noted for its straightforward installation process, appealing to those who prioritize quick deployment.
- Reviewers mention that Google Cloud BigQuery's quality of support is rated at 8.3, which is generally satisfactory, but ClickHouse scores slightly higher at 8.5, indicating a more responsive support system that users appreciate.
Featured Products
Sponsored
WarpStream
(0)
Data Warehouse
Visit Website
Sponsored
Reaktion
(2)
Data Warehouse
Visit Website
Sponsored
Help Desk Migration Services
(166)
Data Warehouse
Visit Website
Pricing
Entry-Level Pricing
ClickHouse
ClickHouse Pricing
Starting at $1.00
Per Month
Options for every user, organization, and use case.
- Up to 1 TB storage
- 16 GiB total memory
- Burstable CPU
Google Cloud BigQuery
Free
Free
New customers get $300 in free Google Cloud credits to spend on BigQuery with free trial sign-up.
- 10 GB storage
- Up to 1 TB queries per month
Free Trial
ClickHouse
No trial information availableGoogle Cloud BigQuery
Free Trial is available
Ratings
Meets Requirements
8.8
10
8.8
513
Ease of Use
8.5
10
8.7
523
Ease of Setup
8.9
6
8.6
284
Ease of Admin
7.0
5
8.6
197
Quality of Support
8.5
8
8.3
470
Has the product been a good partner in doing business?
Not enough data
8.7
190
Product Direction (% positive)
10.0
9
9.3
501
Features by Category
Management
Not enough data
8.5
59
Not enough data
8.2
57
Functionality
Not enough data
8.8
58
Not enough data
8.9
60
Not enough data
8.9
60
Not enough data
8.9
61
Not enough data
9.3
60
Data Management
Not enough data
8.9
132
|
Verified
Not enough data
8.2
125
|
Verified
Not enough data
8.8
129
|
Verified
Not enough data
8.5
125
|
Verified
Not enough data
8.2
114
|
Verified
Not enough data
8.7
116
|
Verified
Integration
Not enough data
8.4
115
|
Verified
Not enough data
8.6
127
|
Verified
Not enough data
8.6
115
|
Verified
Deployment
Not enough data
7.8
103
|
Verified
Not enough data
9.0
126
|
Verified
Performance
Not enough data
9.1
130
|
Verified
Security
Not enough data
8.8
122
|
Verified
Not enough data
9.1
127
|
Verified
Generative AI
Not enough data
Feature Not Available
Not enough data
Feature Not Available
Management
9.4
6
Not enough data
7.9
7
Not enough data
9.3
7
Not enough data
9.4
6
Not enough data
10.0
5
Not enough data
Maintenance
8.8
7
Not enough data
7.8
6
Not enough data
Not enough data
Not enough data
Security
Not enough data
Not enough data
Not enough data
Not enough data
Management
Not enough data
Not enough data
9.3
5
Not enough data
Feature Not Available
Not enough data
Not enough data
Not enough data
Support
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Security
Feature Not Available
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Performance
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Database Features
9.0
5
Not enough data
9.3
5
Not enough data
9.0
5
Not enough data
9.0
5
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
8.7
5
Not enough data
Storage
9.0
5
8.9
49
8.9
6
8.8
48
Availability
Feature Not Available
8.6
42
7.3
5
8.6
45
8.0
5
8.5
47
Performance
7.7
5
8.7
45
Security
Not enough data
8.5
49
Not enough data
8.6
48
Not enough data
8.4
47
Not enough data
8.6
43
Support
Not enough data
8.7
45
Not enough data
8.8
43
Centralized computation
Not enough data
8.8
7
Localized computation
Not enough data
8.6
7
Query latency
Not enough data
Not enough data
Not enough data
Not enough data
Data latency
Not enough data
Not enough data
Not enough data
Not enough data
Connectors
Not enough data
Not enough data
Not enough data
Not enough data
Scale
Not enough data
Not enough data
Not enough data
Not enough data
Architecture
Not enough data
Not enough data
Not enough data
Not enough data
Statistical Tool
Not enough data
8.6
45
Not enough data
8.9
47
Not enough data
8.9
46
Data Analysis
Not enough data
9.2
45
Not enough data
9.1
46
Decision Making
Not enough data
8.8
47
Not enough data
8.6
46
Not enough data
8.5
47
Not enough data
8.5
45
Generative AI
Not enough data
Feature Not Available
Not enough data
Feature Not Available
Marketing Operations
Not enough data
8.8
45
Not enough data
9.0
43
Not enough data
9.0
44
Not enough data
9.4
45
Not enough data
8.9
42
Not enough data
8.5
42
Campaign Activity
Not enough data
9.0
47
Not enough data
9.4
46
Not enough data
8.6
43
Not enough data
9.1
41
Not enough data
8.9
43
Not enough data
9.1
44
Database
Not enough data
8.6
122
Not enough data
8.7
120
Not enough data
8.5
114
Integrations
Not enough data
8.0
85
Not enough data
8.4
81
Platform
Not enough data
8.7
98
Not enough data
8.7
113
Not enough data
8.4
81
Processing
Not enough data
9.2
114
Not enough data
9.0
109
Data Transformation
Not enough data
8.8
211
Not enough data
9.3
218
Connectivity
Not enough data
8.1
181
Not enough data
8.2
180
Not enough data
8.7
207
Not enough data
8.8
199
Operations
Not enough data
8.5
209
Not enough data
8.7
205
Not enough data
8.5
185
Not enough data
8.4
192
Not enough data
8.5
183
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
ClickHouse and Google Cloud BigQuery are categorized as Columnar Databases
Unique Categories
ClickHouse is categorized as Real-time Analytic Database, Database Management Systems (DBMS), and Relational Databases
Google Cloud BigQuery is categorized as Big Data Integration Platforms, ETL Tools, Big Data Processing and Distribution, Big Data Analytics, Marketing Analytics, Predictive Analytics, Data Warehouse, and Data Clean Room
Reviews
Reviewers' Company Size
ClickHouse
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Google Cloud BigQuery
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
33.3%
Computer Software
16.7%
Wholesale
5.6%
Telecommunications
5.6%
Marketing and Advertising
5.6%
Other
33.3%
Information Technology and Services
13.9%
Computer Software
13.2%
Retail
7.7%
Financial Services
7.2%
Marketing and Advertising
5.4%
Other
52.5%
Most Helpful Reviews
ClickHouse
Most Helpful Favorable Review
Daksh P.
Verified User in Information Technology and Services
Basically, clickhouse DB is column-oriented and so whenever we are using a query to fetch a huge amount of data it provides a result in less time. it's so amazing as we can quicky retrive the millions of records to analyze the data. Clickhouse having a nice...
Most Helpful Critical Review
Verified User in Wholesale
As of now, Nothing I dislike about click house.
Google Cloud BigQuery
Most Helpful Favorable Review
Mohammed M.
Verified User in Information Technology and Services
a cost effective data warehouse which helps to get analytics about the data either via public dataset or custom upload
Most Helpful Critical Review
Rishabh S.
Verified User in Computer Software
Cost can be high with large data volumes and frequent queries.
Daksh P.
Verified User in Information Technology and Services
Basically, clickhouse DB is column-oriented and so whenever we are using a query to fetch a huge amount of data it provides a result in less time. it's so amazing as we can quicky retrive the millions of records to analyze the data. Clickhouse having a nice...
Mohammed M.
Verified User in Information Technology and Services
a cost effective data warehouse which helps to get analytics about the data either via public dataset or custom upload
Verified User in Wholesale
As of now, Nothing I dislike about click house.
Rishabh S.
Verified User in Computer Software
Cost can be high with large data volumes and frequent queries.
Alternatives
Discussions
ClickHouse has no discussions with answers
Is Big Query free?
3 comments
BG
NoRead more
Is BigQuery part of Google Cloud Platform?
2 comments
AY
Yes, Bigquery is a GCP product and a serveless data wharehouse.Read more
How BQ legacy SQl is different form the standard SQL?
1 comment
OD
Legacy SQL is a non-standard SQL only used by BigQuery. Standard SQL is compliant with the SQL 2011.
Google recommends using Standard SQL and looking at the...Read more
Hunting for software insights?
With over 2.5 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
or continue with
Gmail.com addresses not permitted. A business domain using Google is allowed.
By proceeding, you agree to our Terms of Use and Privacy Policy
