Introducing G2.ai, the future of software buying.Try now
Compare Google Cloud BigQuery and Snowflake 
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.
Alteryx
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
Enterprise (38.1% of reviews)
Enterprise (44.9% of reviews)
Entry-Level Pricing
Free
$2 Compute/Hour
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 plansSnowflake
Star Rating
(666)4.6 out of 5
Market Segments
Enterprise (44.9% of reviews)
Pros & Cons
Entry-Level Pricing
$2 Compute/Hour
Free Trial is available
Browse all 4 pricing plansSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Google Cloud BigQuery excels in its Data Querying capabilities, scoring 9.3, which reviewers mention allows for fast and efficient querying of large datasets. In contrast, Snowflake, while also strong at 9.4, is noted for its Data Distribution features, scoring 9.3, which users say enhances performance by optimizing data storage and retrieval.
- Reviewers mention that Snowflake's Ease of Use is a standout feature, scoring 9.0, making it more accessible for users who may not have extensive technical backgrounds. Google Cloud BigQuery, with a score of 8.7, is still user-friendly but may require a steeper learning curve according to some users.
- G2 users highlight Snowflake's superior Data Quality score of 9.0, which reviewers say ensures more reliable analytics outcomes. Google Cloud BigQuery, while respectable at 8.9, is perceived to have slightly less robust data validation features.
- Users on G2 report that Snowflake's Auto Recovery feature, scoring 9.2, provides peace of mind with its ability to quickly restore data after failures. Google Cloud BigQuery, at 8.5, offers recovery options but lacks the same level of automation and user satisfaction.
- Reviewers mention that Google Cloud BigQuery shines in Cloud Processing, scoring 9.2, which users say allows for seamless integration with other Google services. Snowflake, with a score of 9.3, is praised for its Cloud Scalability, enabling users to easily adjust resources based on workload demands.
- Users say that Snowflake's Data Governance features, scoring 8.9, are more comprehensive, providing better control over data access and compliance. Google Cloud BigQuery, while scoring 8.7, is noted for its strong security measures but may not offer the same level of governance tools as Snowflake.
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
Snowflake
Standard
$2
Compute/Hour
Compute usage is billed on a per-second basis, with a minimum of 60 seconds. You can secure price discounts with pre-purchased Snowflake capacity options.
- Complete SQL Data Warehouse
- Secure Data Sharing across regions / clouds
- Premier Support 24 x 365
Free Trial
Google Cloud BigQuery
Free Trial is available
Snowflake
Free Trial is available
Ratings
Meets Requirements
8.8
612
9.1
504
Ease of Use
8.7
626
9.0
540
Ease of Setup
8.8
401
8.9
325
Ease of Admin
8.5
224
8.6
204
Quality of Support
8.4
564
8.7
461
Has the product been a good partner in doing business?
8.7
217
9.0
205
Product Direction (% positive)
9.2
600
9.2
474
Features by Category
Management
8.6
123
Not enough data
8.3
121
Not enough data
Functionality
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
Not enough data
Deployment
Not enough data
9.2
12
Not enough data
8.9
12
Not enough data
9.0
12
Not enough data
9.3
12
Not enough data
9.3
12
Deployment
Not enough data
9.3
10
Not enough data
9.5
10
Not enough data
9.5
10
Not enough data
9.5
10
Not enough data
9.3
10
Management
Not enough data
9.2
12
Not enough data
9.0
12
Not enough data
9.2
12
Not enough data
9.0
12
Operations
Not enough data
8.8
10
Not enough data
8.8
10
Not enough data
9.5
10
Management
Not enough data
9.2
10
Not enough data
9.3
9
Not enough data
9.0
10
Generative AI
Not enough data
8.7
10
Not enough data
8.3
10
System
Not enough data
9.2
28
Model Development
Not enough data
9.1
27
Not enough data
8.5
27
Not enough data
8.3
27
Not enough data
8.7
27
Model Development
Not enough data
8.7
27
Machine/Deep Learning Services
Not enough data
8.6
27
Not enough data
8.6
27
Not enough data
8.4
27
Not enough data
8.4
26
Machine/Deep Learning Services
Not enough data
8.5
27
Not enough data
8.5
24
Deployment
Not enough data
9.1
29
Not enough data
9.0
27
Not enough data
9.3
27
Generative AI
Not enough data
8.4
25
Not enough data
8.3
25
Not enough data
8.5
25
Agentic AI - Data Science and Machine Learning Platforms
Not enough data
8.2
13
Not enough data
8.2
13
Not enough data
8.3
13
Not enough data
8.5
13
Not enough data
8.2
13
Not enough data
8.3
13
Not enough data
8.2
12
Data Management
8.9
223
|
Verified
9.0
183
|
Verified
8.3
214
|
Verified
8.9
168
|
Verified
8.9
219
|
Verified
9.0
175
|
Verified
8.6
215
|
Verified
8.3
170
|
Verified
8.3
204
|
Verified
8.2
150
|
Verified
8.7
205
|
Verified
8.7
154
|
Verified
Integration
8.6
204
|
Verified
8.2
141
|
Verified
8.6
216
|
Verified
8.9
169
|
Verified
8.6
204
|
Verified
8.8
159
|
Verified
Deployment
7.8
190
|
Verified
7.8
140
|
Verified
9.1
215
|
Verified
9.2
175
|
Verified
Performance
9.1
220
|
Verified
9.2
178
|
Verified
Security
8.7
211
|
Verified
8.9
165
|
Verified
9.2
217
|
Verified
9.1
176
|
Verified
Generative AI
7.7
132
8.0
79
7.9
129
8.1
80
Management
Not enough data
8.9
83
Not enough data
9.2
83
Not enough data
9.5
88
Not enough data
9.0
86
Not enough data
9.1
87
Maintenance
Not enough data
9.3
85
Not enough data
9.0
84
Not enough data
9.3
85
Security
Not enough data
9.2
85
Not enough data
9.2
88
Storage
9.1
70
9.2
44
8.8
70
9.2
44
Availability
8.4
62
9.1
39
8.5
66
9.2
37
8.6
68
9.2
41
Performance
8.5
65
9.2
44
Security
8.7
70
9.1
44
8.8
69
9.2
45
8.4
69
8.9
38
8.7
65
9.2
38
Support
8.7
66
9.2
36
8.9
66
9.1
35
Centralized computation
9.1
27
9.3
25
Localized computation
8.5
28
9.0
24
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
8.9
98
8.9
176
9.3
101
8.8
170
9.3
95
Integrations
8.4
139
8.6
76
8.6
136
8.7
81
Platform
8.9
153
9.1
91
8.9
168
9.0
97
8.6
136
8.7
81
Processing
9.3
170
9.3
96
9.1
164
9.1
94
Data Transformation
8.8
288
9.2
86
9.3
295
9.4
86
Connectivity
8.1
256
8.5
78
8.2
254
8.7
79
8.7
283
9.1
80
8.8
274
9.1
81
Operations
8.5
283
8.6
83
8.7
282
9.2
79
8.3
260
8.9
75
8.4
267
8.8
80
8.5
259
8.7
77
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 Snowflake are categorized as Columnar Databases, Big Data Integration Platforms, Big Data Processing and Distribution, Big Data Analytics, Data Warehouse, and Data Clean Room
Unique Categories
Snowflake is categorized as MLOps Platforms, Database Management Systems (DBMS), and Data Science and Machine Learning Platforms
Reviews
Reviewers' Company Size
Google Cloud BigQuery
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Snowflake
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
14.3%
Computer Software
13.0%
Financial Services
10.4%
Marketing and Advertising
4.7%
Hospital & Health Care
3.7%
Other
53.8%
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's the best way to manage change data capture in Snowflake?
4 Comments
VT
Please go through this link: https://docs.snowflake.com/en/user-guide/streams
You might get a pertinent response from it.
Please click on this link...Read more
which is best snowflake or My sql
2 Comments
LH
Depends on your needs. MySQL is open source/free. It or Postgres (another open source db) is good for pretty much any normal need. You can install on...Read more
What is the difference between Snowflake vs Redshift? Which one is Good to Learn.
2 Comments
DW
I've used both; Snowflake is superior in my view. Redshift certainly offers a lot of power being an AWS product, however Snowflake is more fully-featured....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.
