Compare Google Cloud BigQuery and dbt 
Featured Products
At a Glance
Market Segments
Enterprise (38.1% of reviews)
Mid-Market (57.4% of reviews)
Entry-Level Pricing
Free
No pricing available
Google Cloud BigQuery
Star Rating
(1,224)4.5 out of 5
Market Segments
Enterprise (38.1% of reviews)
Pros & Cons
Entry-Level Pricing
Free
Browse all 5 pricing plansdbt
Star Rating
(198)4.7 out of 5
Market Segments
Mid-Market (57.4% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about dbtSummary
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 dbt. Users appreciate its serverless architecture and the ability to focus on clean SQL without worrying about infrastructure, making data analysis feel smooth and efficient.
- Users say that dbt shines in its ease of setup and daily usability, with many finding it very easy to integrate into their workflows. Reviewers highlight its ability to provide structure to data work, which facilitates teamwork and enhances productivity.
- According to verified reviews, Google Cloud BigQuery is praised for its scalability and pay-as-you-go model, allowing users to experiment with larger datasets without the need for provisioning clusters. This flexibility is a major advantage for organizations looking to optimize costs while handling vast amounts of data.
- Reviewers mention that while dbt offers strong automation capabilities for data transformation, Google Cloud BigQuery's performance in handling billions of queries efficiently makes it a preferred choice for users needing high-speed analytics.
- Users highlight that Google Cloud BigQuery's quality of support is slightly lower than dbt's, with some noting that while BigQuery is powerful, they sometimes encounter challenges in getting timely assistance. In contrast, dbt users report a more responsive support experience, which can be crucial for teams relying on quick resolutions.
- G2 reviewers indicate that both products have their strengths in data transformation, but dbt's focus on version control and collaboration tools makes it particularly appealing for teams that prioritize structured data workflows. Users appreciate how dbt automates the creation of data models, instilling confidence in the accuracy of their KPIs.
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
626
9.2
146
Ease of Use
8.7
642
9.0
148
Ease of Setup
8.7
416
8.6
87
Ease of Admin
8.5
227
8.5
59
Quality of Support
8.3
573
8.9
117
Has the product been a good partner in doing business?
8.6
220
8.6
53
Product Direction (% positive)
9.3
614
9.6
133
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
47
Not enough data
9.2
50
Not enough data
8.6
41
Data Interaction
Not enough data
8.3
40
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
47
Not enough data
8.7
45
Data Exporting
Not enough data
8.5
41
Not enough data
8.7
44
Not enough data
9.1
45
Generative AI
Not enough data
6.5
27
Management
8.6
121
Feature Not Available
8.3
119
8.2
37
Functionality
9.0
119
Feature Not Available
9.1
123
9.3
45
9.0
123
Feature Not Available
8.9
122
9.5
40
9.3
122
9.2
37
Data Management
8.9
224
|
Verified
Not enough data
8.3
210
|
Verified
Not enough data
8.9
215
|
Verified
Not enough data
8.6
219
|
Verified
Not enough data
8.3
204
|
Verified
Not enough data
8.6
201
|
Verified
Not enough data
Integration
8.5
202
|
Verified
Not enough data
8.6
214
|
Verified
Not enough data
8.6
201
|
Verified
Not enough data
Deployment
7.7
186
|
Verified
Not enough data
9.1
223
|
Verified
Not enough data
Performance
9.1
233
|
Verified
Not enough data
Security
8.7
208
|
Verified
Not enough data
9.2
214
|
Verified
Not enough data
Generative AI
7.6
127
Not enough data
7.8
124
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
49
Agentic AI - DataOps Platforms
Not enough data
7.5
8
Not enough data
7.4
7
Not enough data
8.1
9
Not enough data
8.1
9
Not enough data
8.3
8
Analytics
Not enough data
8.8
48
Not enough data
7.3
34
Monitoring and Management
Not enough data
8.7
43
Not enough data
8.9
51
Cloud Deployment
Not enough data
8.7
37
Not enough data
8.8
29
Generative AI
Not enough data
5.7
12
Not enough data
6.0
12
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
34
Not enough data
8.4
34
Administration
Not enough data
8.4
37
Not enough data
8.9
34
Not enough data
9.1
35
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
78
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
79
Not enough data
8.7
77
Not enough data
8.7
79
Not enough data
8.7
77
Not enough data
Generative AI
7.5
50
Not enough data
7.8
50
Not enough data
Marketing Operations
8.8
65
Not enough data
9.2
64
Not enough data
8.9
64
Not enough data
9.4
65
Not enough data
8.8
63
Not enough data
8.4
62
Not enough data
Campaign Activity
9.1
67
Not enough data
9.5
67
Not enough data
8.7
64
Not enough data
9.2
61
Not enough data
8.9
62
Not enough data
9.0
64
Not enough data
Agentic AI - Marketing Analytics
8.7
15
Not enough data
9.6
15
Not enough data
8.2
15
Not enough data
Database
8.8
175
Not enough data
8.9
173
Not enough data
8.7
167
Not enough data
Integrations
8.4
136
Not enough data
8.5
133
Not enough data
Platform
8.9
151
Not enough data
8.9
165
Not enough data
8.5
133
Not enough data
Processing
9.2
168
Not enough data
9.1
161
Not enough data
Data Transformation
8.8
283
8.5
32
9.3
293
9.4
39
Connectivity
8.1
251
8.4
27
8.2
249
8.6
28
8.7
278
8.5
34
8.7
269
8.9
31
Operations
8.5
279
Feature Not Available
8.7
277
9.3
38
8.3
255
8.6
30
8.4
262
8.7
30
8.5
254
8.6
30
Functionality
Not enough data
8.7
39
Not enough data
8.3
36
Not enough data
8.7
40
Not enough data
8.2
38
Not enough data
8.4
38
Management
Not enough data
8.5
40
Not enough data
9.3
42
Not enough data
8.8
36
Not enough data
8.1
39
Not enough data
8.3
41
Generative AI
Not enough data
6.2
19
Not enough data
6.6
19
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.1%
Computer Software
13.5%
Retail
7.0%
Financial Services
6.5%
Marketing and Advertising
5.2%
Other
51.7%
Information Technology and Services
19.5%
Computer Software
16.4%
Financial Services
10.3%
Retail
4.6%
Marketing and Advertising
4.6%
Other
44.6%
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.
