Introducing G2.ai, the future of software buying.Try now
Compare Dremio 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.
Starburst
Visit Website
At a Glance
Market Segments
Enterprise (47.6% of reviews)
Enterprise (38.0% of reviews)
Entry-Level Pricing
No pricing available
Free
Dremio
Star Rating
(69)4.6 out of 5
Market Segments
Enterprise (47.6% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about DremioGoogle Cloud BigQuery
Star Rating
(1,205)4.5 out of 5
Market Segments
Enterprise (38.0% 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.
- G2 reviewers report that Google Cloud BigQuery excels in overall user satisfaction, boasting a significantly higher G2 Score compared to Dremio. Users appreciate its serverless architecture and the ability to focus on SQL without worrying about infrastructure, making data analysis feel smooth and efficient.
- Users say that Dremio shines in its ease of use, particularly during the onboarding process. Many reviewers highlight how quickly they could connect to multiple data sources without a complicated setup, which is a major plus for teams looking to get started quickly.
- According to verified reviews, Google Cloud BigQuery's performance in handling large datasets is impressive, with users noting its ability to process billions of queries efficiently. This capability is enhanced by its pay-as-you-go model, which simplifies operations and encourages experimentation.
- Reviewers mention that while Dremio offers strong integration capabilities with various data sources, including relational and NoSQL databases, it still faces challenges in overall performance metrics compared to BigQuery. Users appreciate Dremio's ability to query directly from S3 and HDFS, but some feel it lacks the same level of speed and efficiency.
- G2 reviewers highlight that Google Cloud BigQuery provides a robust set of built-in analytics tools, which many users find beneficial for their data analysis needs. The integration of BigQuery ML and AI tooling is particularly noted as a game-changer for teams looking to leverage machine learning capabilities.
- Users report that Dremio's support quality is commendable, with a slightly higher rating than BigQuery. However, the overall user experience with BigQuery, including its ease of administration and comprehensive support resources, tends to lead to a more favorable impression among users.
Pricing
Entry-Level Pricing
Dremio
No pricing availableGoogle 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
Dremio
Free Trial is available
Google Cloud BigQuery
Free Trial is available
Ratings
Meets Requirements
8.7
52
8.8
615
Ease of Use
9.2
53
8.7
630
Ease of Setup
8.4
47
8.8
405
Ease of Admin
7.8
29
8.5
226
Quality of Support
8.5
50
8.4
567
Has the product been a good partner in doing business?
9.1
28
8.6
219
Product Direction (% positive)
9.7
46
9.2
603
Features by Category
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
Not enough data
Not enough data
Self Service
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
Advanced Analytics
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
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
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
125
Not enough data
9.0
125
Not enough data
8.9
124
Not enough data
9.4
124
Data Management
8.6
23
8.9
223
|
Verified
8.5
20
8.3
214
|
Verified
8.3
12
8.9
219
|
Verified
7.7
20
8.6
216
|
Verified
Feature Not Available
8.4
205
|
Verified
8.9
23
8.7
205
|
Verified
Integration
Feature Not Available
8.6
204
|
Verified
8.8
21
8.7
217
|
Verified
9.0
22
8.6
204
|
Verified
Deployment
8.7
15
7.8
190
|
Verified
8.5
19
9.1
216
|
Verified
Performance
8.3
21
9.1
223
|
Verified
Security
8.2
20
8.7
211
|
Verified
Feature Not Available
9.2
217
|
Verified
Generative AI
6.9
12
7.7
132
Not enough data
7.9
129
Storage
Not enough data
9.1
70
Not enough data
8.8
70
Availability
Not enough data
8.4
62
Not enough data
8.5
66
Not enough data
8.6
68
Performance
Not enough data
8.5
65
Security
Not enough data
8.7
70
Not enough data
8.8
69
Not enough data
8.4
69
Not enough data
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
Data Management
8.6
11
Not enough data
8.8
11
Not enough data
Feature Not Available
Not enough data
Data as a Service
7.6
11
Not enough data
8.2
11
Not enough data
Architecture
8.2
11
Not enough data
8.6
11
Not enough data
Deployment & Integration - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Data Connectivity & Federation - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Data Modeling & Metrics - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Performance Optimization - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Governance - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Advanced Intelligence - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Agentic AI Enablement - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Statistical Tool
Not enough data
8.7
79
Not enough data
9.0
79
Not enough data
8.8
80
Data Analysis
Not enough data
9.3
79
Not enough data
9.1
80
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
65
Not enough data
8.9
65
Not enough data
9.4
66
Not enough data
8.8
64
Not enough data
8.5
63
Campaign Activity
Not enough data
9.1
68
Not enough data
9.5
68
Not enough data
8.7
65
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
Feature Not Available
8.8
178
Feature Not Available
8.9
176
Feature Not Available
8.8
170
Integrations
9.0
18
8.4
139
7.9
13
8.6
136
Platform
9.1
20
8.9
154
8.7
13
8.9
168
7.9
13
8.6
136
Processing
9.1
18
9.3
171
8.6
13
9.1
164
Data Transformation
Feature Not Available
8.8
288
9.2
24
9.3
297
Connectivity
8.6
22
8.1
256
Feature Not Available
8.2
254
8.9
23
8.7
283
8.9
25
8.8
274
Operations
7.2
25
8.5
283
7.1
25
8.7
282
7.8
27
8.3
260
7.7
21
8.4
267
7.0
21
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
Dremio and Google Cloud BigQuery are categorized as Big Data Processing and Distribution, Big Data Analytics, and Data Warehouse
Unique Categories
Dremio is categorized as Data as a Service (DaaS) and Semantic Layer Tools
Google Cloud BigQuery is categorized as Columnar Databases, Big Data Integration Platforms, ETL Tools, Marketing Analytics, Predictive Analytics, and Data Clean Room
Reviews
Reviewers' Company Size
Dremio
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
Financial Services
23.8%
Information Technology and Services
11.1%
Computer Software
7.9%
Marketing and Advertising
4.8%
Automotive
4.8%
Other
47.6%
Information Technology and Services
16.2%
Computer Software
13.4%
Retail
7.1%
Financial Services
6.4%
Marketing and Advertising
5.1%
Other
51.7%
Alternatives
Discussions
What is a Dremio reflection?
1 Comment
Official Response from Dremio
A reflection is an optimized materialization of source data or a query, similar to a materialized view, that is derived from an existing table or view. A...Read more
Dremio has no more discussions with answers
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.
