Introducing G2.ai, the future of software buying.Try now
Compare Google Cloud BigQuery and dbt 
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.
Astro by Astronomer
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.
QuerySurge
Visit Website
At a Glance
Market Segments
Enterprise (38.1% of reviews)
Mid-Market (57.9% 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 plansdbt
Star Rating
(193)4.7 out of 5
Market Segments
Mid-Market (57.9% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Free Trial is available
Learn more about dbtSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Google Cloud BigQuery excels in data integration, scoring 9.0, which allows seamless connectivity to various data sources. In contrast, dbt, while strong in data transformation with a score of 9.4, does not focus as heavily on integration capabilities.
- Reviewers mention that BigQuery's real-time analytics capabilities are rated at 8.8, making it a preferred choice for users needing immediate insights. On the other hand, dbt's real-time analytics score is lower at 7.7, indicating it may not be as effective for users requiring instant data processing.
- G2 users highlight that BigQuery's quality of support is rated at 8.3, which is lower than dbt's 8.9. Reviewers mention that dbt provides more responsive and helpful customer service, enhancing the overall user experience.
- Users on G2 report that BigQuery's data quality features score 8.8, which is a strong point for ensuring accurate data analysis. In contrast, dbt's data quality features, while still good, score slightly lower, indicating that users may find BigQuery more reliable for maintaining data integrity.
- Reviewers mention that dbt shines in automation with a score of 9.3, allowing users to streamline their workflows effectively. BigQuery, while also strong in automation at 8.9, does not match dbt's level of efficiency in this area.
- Users say that BigQuery's scalability is rated at 9.3, making it ideal for enterprises with growing data needs. In comparison, dbt's scalability score of 9.2 is still impressive but indicates that BigQuery may handle larger datasets more effectively.
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
dbt
No pricing availableFree Trial
Google Cloud BigQuery
Free Trial is available
dbt
Free Trial is available
Ratings
Meets Requirements
8.8
612
9.2
141
Ease of Use
8.7
626
9.0
143
Ease of Setup
8.8
401
8.6
82
Ease of Admin
8.5
224
8.5
58
Quality of Support
8.4
564
8.9
113
Has the product been a good partner in doing business?
8.7
217
8.8
52
Product Direction (% positive)
9.2
600
9.7
128
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
Data Source Access
Not enough data
8.8
48
Not enough data
9.2
50
Not enough data
8.6
41
Data Interaction
Not enough data
8.3
41
Not enough data
8.5
44
Not enough data
9.0
50
Not enough data
9.1
48
Not enough data
9.1
42
Not enough data
9.4
48
Not enough data
8.7
46
Not enough data
8.7
45
Data Exporting
Not enough data
8.5
42
Not enough data
8.6
44
Not enough data
9.1
46
Generative AI
Not enough data
6.5
27
Management
8.6
123
Feature Not Available
8.3
121
8.2
36
Functionality
9.0
121
Feature Not Available
9.1
124
9.2
41
9.0
124
Feature Not Available
8.9
123
9.4
38
9.4
124
9.2
36
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
Data Management
Not enough data
9.2
50
Not enough data
9.1
52
Not enough data
9.1
49
Not enough data
9.3
50
Agentic AI - DataOps Platforms
Not enough data
7.6
9
Not enough data
7.7
8
Not enough data
8.3
10
Not enough data
8.0
9
Not enough data
8.5
9
Analytics
Not enough data
8.7
47
Not enough data
7.3
35
Monitoring and Management
Not enough data
8.7
43
Not enough data
8.9
50
Cloud Deployment
Not enough data
8.8
38
Not enough data
8.8
30
Generative AI
Not enough data
5.9
13
Not enough data
6.3
13
Automation
Not enough data
8.8
34
Not enough data
8.3
32
Not enough data
8.6
35
Not enough data
Feature Not Available
Functionality
Not enough data
8.6
34
Not enough data
8.6
33
Not enough data
8.4
33
Administration
Not enough data
8.4
36
Not enough data
8.9
34
Not enough data
9.1
34
Agentic AI - Data Warehouse Automation
Not enough data
Not enough data
Centralized computation
9.1
27
Not enough data
Localized computation
8.5
28
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
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
8.5
32
9.3
295
9.4
39
Connectivity
8.1
256
8.5
27
8.2
254
8.6
28
8.7
283
8.5
34
8.8
274
9.0
31
Operations
8.5
283
Feature Not Available
8.7
282
9.4
38
8.3
260
8.6
31
8.4
267
8.6
30
8.5
259
8.6
30
Functionality
Not enough data
8.7
39
Not enough data
8.4
36
Not enough data
8.6
39
Not enough data
8.2
38
Not enough data
8.4
37
Management
Not enough data
8.4
38
Not enough data
9.2
42
Not enough data
8.9
37
Not enough data
8.2
39
Not enough data
8.3
42
Generative AI
Not enough data
6.3
20
Not enough data
6.7
20
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 dbt are categorized as Big Data Integration Platforms, ETL Tools, and Big Data Analytics
Unique Categories
Google Cloud BigQuery is categorized as Columnar Databases, Big Data Processing and Distribution, Marketing Analytics, Predictive Analytics, Data Warehouse, and Data Clean Room
dbt is categorized as Data Preparation, Data Quality, Data Warehouse Automation, DataOps Platforms, and Semantic Layer Tools
Reviews
Reviewers' Company Size
Google Cloud BigQuery
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
dbt
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
19.5%
Computer Software
16.3%
Financial Services
10.5%
Retail
4.7%
Marketing and Advertising
4.7%
Other
44.2%
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
What is DBT data Modelling?
2 Comments
TH
dbt data modeling is not a thing. Dbt is a transformation tool that makes it easier to implement data modeling techniques like snowflake, data vault etc. Read more
What is DBT database tool?
1 Comment
SY
DBT (DataBase Transformations) uses SQL select statements, with some added magic from Jinja templating language, to model and transform data. It's a highly...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.
