Introducing G2.ai, the future of software buying.Try now
Compare Google Cloud BigQuery and Pentaho Data Integration 
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.
Adcredo
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.
High Digital
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.
Kpow for Apache Kafka®
Visit Website
At a Glance
Market Segments
Enterprise (38.1% of reviews)
Mid-Market (41.2% of reviews)
Entry-Level Pricing
Free
No pricing available
Google 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 plansPentaho Data Integration
Star Rating
(17)4.3 out of 5
Market Segments
Mid-Market (41.2% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Pentaho Data IntegrationSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Google Cloud BigQuery excels in scalability, with a score of 9.3, allowing for efficient handling of large datasets, while Pentaho Data Integration, with a score of 9.1, also offers good scalability but may not match the performance of BigQuery in extremely large environments.
- Reviewers mention that BigQuery's built-in data analytics features, rated at 8.6, provide robust capabilities for real-time insights, whereas Pentaho's data transformation capabilities, rated at 9.0, are highlighted for their flexibility and ease of use in complex data workflows.
- G2 users indicate that BigQuery's integration with AI/ML tools, rated at 8.5, enhances its functionality for predictive analytics, while Pentaho's strong support for data migration and transformation processes, rated at 9.0, is praised for its user-friendly interface and no-code functionality.
- Reviewers say that BigQuery's performance in data querying, with a score of 9.3, is superior, enabling faster data retrieval, while Pentaho's reporting capabilities, rated at 8.5, are noted for their customization options, allowing users to create tailored reports easily.
- Users on G2 highlight that BigQuery's cloud-based deployment, rated at 9.1, offers significant advantages in terms of accessibility and maintenance, while Pentaho's on-premise option, rated at 7.9, is preferred by organizations needing more control over their data environment.
- Reviewers mention that BigQuery's quality of support, rated at 8.3, is generally reliable, but some users feel that Pentaho's support, rated at 7.3, could improve, particularly in response times and technical assistance for complex issues.
Pricing
Entry-Level Pricing
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
Pentaho Data Integration
No pricing availableFree Trial
Google Cloud BigQuery
Free Trial is available
Pentaho Data Integration
No trial information availableRatings
Meets Requirements
8.8
612
8.7
15
Ease of Use
8.7
626
8.6
15
Ease of Setup
8.8
401
8.0
9
Ease of Admin
8.5
224
8.6
7
Quality of Support
8.4
564
7.2
12
Has the product been a good partner in doing business?
8.7
217
8.6
6
Product Direction (% positive)
9.2
600
9.2
14
Features by Category
Management
8.6
123
8.7
5
8.3
121
9.0
5
Functionality
9.0
121
9.7
5
9.1
124
9.7
5
9.0
124
9.3
5
8.9
123
8.3
5
9.4
124
8.7
5
Functionality
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Management
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
Not enough data
Not enough data
Agentic AI - Cloud Migration
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Functionality
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
Not enough data
Not enough data
Data Management
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
Not enough data
Integration
8.6
204
|
Verified
Not enough data
8.6
216
|
Verified
Not enough data
8.6
204
|
Verified
Not enough data
Deployment
7.8
190
|
Verified
Not enough data
9.1
215
|
Verified
Not enough data
Performance
9.1
220
|
Verified
Not enough data
Security
8.7
211
|
Verified
Not enough data
9.2
217
|
Verified
Not enough data
Generative AI
7.7
132
Not enough data
7.9
129
Not enough data
Storage
9.1
70
Not enough data
8.8
70
Not enough data
Availability
8.4
62
Not enough data
8.5
66
Not enough data
8.6
68
Not enough data
Performance
8.5
65
Not enough data
Security
8.7
70
Not enough data
8.8
69
Not enough data
8.4
69
Not enough data
8.7
65
Not enough data
Support
8.7
66
Not enough data
8.9
66
Not enough data
Centralized computation
9.1
27
Not enough data
Localized computation
8.5
28
Not enough data
Statistical Tool
8.7
78
Not enough data
9.0
79
Not enough data
8.8
79
Not enough data
Data Analysis
9.3
78
Not enough data
9.1
79
Not enough data
Decision Making
8.8
80
Not enough data
8.7
78
Not enough data
8.7
80
Not enough data
8.7
78
Not enough data
Generative AI
7.5
51
Not enough data
7.8
51
Not enough data
Marketing Operations
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
Not enough data
Campaign Activity
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
Not enough data
Agentic AI - Marketing Analytics
8.8
16
Not enough data
9.6
16
Not enough data
8.3
16
Not enough data
Database
8.8
178
Not enough data
8.9
176
Not enough data
8.8
170
Not enough data
Integrations
8.4
139
Not enough data
8.6
136
Not enough data
Platform
8.9
153
Not enough data
8.9
168
Not enough data
8.6
136
Not enough data
Processing
9.3
170
Not enough data
9.1
164
Not enough data
Data Transformation
8.8
288
Not enough data
9.3
295
Not enough data
Connectivity
8.1
256
Not enough data
8.2
254
Not enough data
8.7
283
Not enough data
8.8
274
Not enough data
Operations
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
Not enough data
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
Google Cloud BigQuery and Pentaho Data Integration are categorized as Big Data Integration Platforms, ETL Tools, and Big Data Processing and Distribution
Unique Categories
Google Cloud BigQuery is categorized as Columnar Databases, Big Data Analytics, Marketing Analytics, Predictive Analytics, Data Warehouse, and Data Clean Room
Pentaho Data Integration is categorized as Cloud Migration, On-Premise Data Integration, and Data Mapping
Reviews
Reviewers' Company Size
Google Cloud BigQuery
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Pentaho Data Integration
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
16.2%
Computer Software
13.5%
Retail
7.1%
Financial Services
6.5%
Marketing and Advertising
5.1%
Other
51.7%
Information Technology and Services
35.3%
Telecommunications
11.8%
Banking
11.8%
Internet
5.9%
Information Services
5.9%
Other
29.4%
Alternatives
Discussions
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
Pentaho Data Integration has no discussions with answers
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.
