Introducing G2.ai, the future of software buying.Try now
Compare ClickHouse and Google Cloud BigQuery 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
ER/Studio
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Trackdesk
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Starburst
Visit Website
At a Glance
Market Segments
Small-Business (47.4% of reviews)
Enterprise (38.1% of reviews)
Entry-Level Pricing
Starting at $1.00 Per Month
Free
ClickHouse
Star Rating
(20)4.4 out of 5
Market Segments
Small-Business (47.4% of reviews)
Pros & Cons
Entry-Level Pricing
Starting at $1.00 Per Month
Learn more about ClickHouseGoogle Cloud BigQuery
Star Rating
(1,201)4.5 out of 5
Market Segments
Enterprise (38.1% of reviews)
Pros & Cons
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, with a score of 9.0, allowing seamless connections to 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 BigQuery's query language is highly rated at 9.3, making it user-friendly for complex queries, whereas ClickHouse also scores well at 9.0 but is sometimes seen as less intuitive for new users.
- G2 users highlight BigQuery's performance analysis capabilities, achieving a perfect score of 10.0, which is praised for its speed and efficiency in handling large datasets, while ClickHouse, although performant, has a lower score of 9.0, indicating room for improvement.
- Users on G2 report that BigQuery's data quality features score 8.8, ensuring reliable data processing, while ClickHouse, with a score of 8.9, is also strong but has been noted for occasional inconsistencies in data handling.
- Reviewers mention that BigQuery's built-in data analytics features score 8.6, providing robust analytical tools directly within the platform, while ClickHouse, although it offers analytics, does not have the same level of built-in functionality, leading to a score of 8.5.
- Users say that BigQuery's quality of support is rated at 8.3, with many praising the responsiveness and helpfulness of the support team, while ClickHouse, with a score of 8.5, is also well-regarded but has fewer reviews, indicating less user feedback on support experiences.
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.9
11
8.8
612
Ease of Use
8.6
11
8.7
626
Ease of Setup
9.0
7
8.8
401
Ease of Admin
7.0
5
8.5
224
Quality of Support
8.7
9
8.4
564
Has the product been a good partner in doing business?
Not enough data
8.7
217
Product Direction (% positive)
10.0
10
9.2
600
Features by Category
Management
Not enough data
8.6
123
Not enough data
8.3
121
Functionality
Not enough data
9.0
121
Not enough data
9.1
124
Not enough data
9.0
124
Not enough data
8.9
123
Not enough data
9.4
124
Data Management
Not enough data
8.9
223
|
Verified
Not enough data
8.3
214
|
Verified
Not enough data
8.9
219
|
Verified
Not enough data
8.6
215
|
Verified
Not enough data
8.3
204
|
Verified
Not enough data
8.7
205
|
Verified
Integration
Not enough data
8.6
204
|
Verified
Not enough data
8.6
216
|
Verified
Not enough data
8.6
204
|
Verified
Deployment
Not enough data
7.8
190
|
Verified
Not enough data
9.1
215
|
Verified
Performance
Not enough data
9.1
220
|
Verified
Security
Not enough data
8.7
211
|
Verified
Not enough data
9.2
217
|
Verified
Generative AI
Not enough data
7.7
132
Not enough data
7.9
129
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.2
6
9.1
70
9.0
7
8.8
70
Availability
Feature Not Available
8.4
62
7.8
6
8.5
66
8.3
6
8.6
68
Performance
8.1
6
8.5
65
Security
9.0
5
8.7
70
Not enough data
8.8
69
Not enough data
8.4
69
8.3
5
8.7
65
Support
Not enough data
8.7
66
Not enough data
8.9
66
Centralized computation
Not enough data
9.1
27
Localized computation
Not enough data
8.5
28
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.7
78
Not enough data
9.0
79
Not enough data
8.8
79
Data Analysis
Not enough data
9.3
78
Not enough data
9.1
79
Decision Making
Not enough data
8.8
80
Not enough data
8.7
78
Not enough data
8.7
80
Not enough data
8.7
78
Generative AI
Not enough data
7.5
51
Not enough data
7.8
51
Marketing Operations
Not enough data
8.8
66
Not enough data
9.2
64
Not enough data
8.9
65
Not enough data
9.4
66
Not enough data
8.8
63
Not enough data
8.5
63
Campaign Activity
Not enough data
9.1
68
Not enough data
9.5
67
Not enough data
8.7
64
Not enough data
9.2
62
Not enough data
8.9
63
Not enough data
9.1
65
Agentic AI - Marketing Analytics
Not enough data
8.8
16
Not enough data
9.6
16
Not enough data
8.3
16
Database
Not enough data
8.8
178
Not enough data
8.9
176
Not enough data
8.8
170
Integrations
Not enough data
8.4
139
Not enough data
8.6
136
Platform
Not enough data
8.9
153
Not enough data
8.9
168
Not enough data
8.6
136
Processing
Not enough data
9.3
170
Not enough data
9.1
164
Data Transformation
Not enough data
8.8
288
Not enough data
9.3
295
Connectivity
Not enough data
8.1
256
Not enough data
8.2
254
Not enough data
8.7
283
Not enough data
8.8
274
Operations
Not enough data
8.5
283
Not enough data
8.7
282
Not enough data
8.3
260
Not enough data
8.4
267
Not enough data
8.5
259
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
31.6%
Computer Software
21.1%
Wholesale
5.3%
Telecommunications
5.3%
Marketing and Advertising
5.3%
Other
31.6%
Information Technology and Services
16.2%
Computer Software
13.5%
Retail
7.1%
Financial Services
6.5%
Marketing and Advertising
5.1%
Other
51.7%
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 3 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.
