Introducing G2.ai, the future of software buying.Try now
Compare Amazon Redshift 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
Mid-Market (39.5% of reviews)
Enterprise (38.1% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
Free
Amazon Redshift
Star Rating
(397)4.3 out of 5
Market Segments
Mid-Market (39.5% of reviews)
Pros & Cons
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plansGoogle 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 plansSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Google Cloud BigQuery excels in data integration with a score of 9.0, allowing seamless connections to various data sources, while Amazon Redshift, with a score of 8.8, is noted for its robust integration capabilities but may require more manual setup.
- Reviewers mention that Google Cloud BigQuery's built-in data analytics feature scores 8.6, providing powerful analytics tools directly within the platform, whereas Amazon Redshift's score of 8.1 indicates that users find its analytics capabilities less intuitive and more reliant on external tools.
- G2 users highlight Google Cloud BigQuery's superior scalability with a score of 9.3, making it ideal for handling large datasets effortlessly, while Amazon Redshift, scoring 8.9, is seen as effective but may struggle with performance under extreme loads.
- Users on G2 report that Google Cloud BigQuery's real-time analytics feature scores 8.8, allowing for immediate insights, while Amazon Redshift's score of 8.6 suggests it offers real-time capabilities but with some latency issues in high-demand scenarios.
- Reviewers mention that Google Cloud BigQuery's data security features, scoring 9.1, are robust, with strong encryption and role-based authorization, while Amazon Redshift, with a score of 8.8, provides solid security but has been noted for slightly less comprehensive governance features.
- Users say that Google Cloud BigQuery's customer support is rated at 8.3, with many praising its responsiveness and helpfulness, while Amazon Redshift's support, scoring 8.5, is also well-regarded but some users feel it could be more proactive in addressing issues.
Pricing
Entry-Level Pricing
Amazon Redshift
RA3.4xlarge
$1.22 - $3.26
Per hour
On-demand, 1-Year, or 3-Year Terms
- Commit to save up to 34%
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
Free Trial
Amazon Redshift
Free Trial is available
Google Cloud BigQuery
Free Trial is available
Ratings
Meets Requirements
8.7
281
8.8
612
Ease of Use
8.7
281
8.7
626
Ease of Setup
8.6
138
8.8
401
Ease of Admin
8.4
128
8.5
224
Quality of Support
8.5
264
8.4
564
Has the product been a good partner in doing business?
8.7
127
8.7
217
Product Direction (% positive)
8.8
252
9.2
600
Features by Category
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
124
Not enough data
9.0
124
Not enough data
8.9
123
Not enough data
9.4
124
Data Management
8.8
133
|
Verified
8.9
223
|
Verified
8.4
125
|
Verified
8.3
214
|
Verified
8.8
131
|
Verified
8.9
219
|
Verified
8.0
127
|
Verified
8.6
215
|
Verified
7.6
102
|
Verified
8.3
204
|
Verified
8.3
118
|
Verified
8.7
205
|
Verified
Integration
7.9
101
|
Verified
8.6
204
|
Verified
8.7
128
|
Verified
8.6
216
|
Verified
8.6
119
|
Verified
8.6
204
|
Verified
Deployment
8.1
102
7.8
190
|
Verified
8.9
130
|
Verified
9.1
215
|
Verified
Performance
8.9
134
|
Verified
9.1
220
|
Verified
Security
8.7
126
|
Verified
8.7
211
|
Verified
8.8
128
|
Verified
9.2
217
|
Verified
Generative AI
7.3
20
7.7
132
7.2
19
7.9
129
Storage
8.4
53
9.1
70
8.4
56
8.8
70
Availability
8.6
47
8.4
62
8.2
50
8.5
66
8.4
48
8.6
68
Performance
8.2
48
8.5
65
Security
8.7
47
8.7
70
8.4
52
8.8
69
8.1
47
8.4
69
8.5
48
8.7
65
Support
7.9
43
8.7
66
8.5
47
8.9
66
Centralized computation
Not enough data
9.1
27
Localized computation
Not enough data
8.5
28
Statistical Tool
Not enough data
8.7
78
Not enough data
9.0
79
Not enough data
8.8
79
Data Analysis
Not enough data
9.3
78
Not enough data
9.1
79
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
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
Campaign Activity
Not enough data
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
Agentic AI - Marketing Analytics
Not enough data
8.8
16
Not enough data
9.6
16
Not enough data
8.3
16
Database
Not enough data
8.8
178
Not enough data
8.9
176
Not enough data
8.8
170
Integrations
Not enough data
8.4
139
Not enough data
8.6
136
Platform
Not enough data
8.9
153
Not enough data
8.9
168
Not enough data
8.6
136
Processing
Not enough data
9.3
170
Not enough data
9.1
164
Data Transformation
Not enough data
8.8
288
Not enough data
9.3
295
Connectivity
Not enough data
8.1
256
Not enough data
8.2
254
Not enough data
8.7
283
Not enough data
8.8
274
Operations
Not enough data
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
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
Amazon Redshift and Google Cloud BigQuery are categorized as Columnar Databases, Data Warehouse, and Big Data Integration Platforms
Unique Categories
Amazon Redshift has no unique categories
Google Cloud BigQuery is categorized as ETL Tools, Big Data Processing and Distribution, Big Data Analytics, Marketing Analytics, Predictive Analytics, and Data Clean Room
Reviews
Reviewers' Company Size
Amazon Redshift
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
Information Technology and Services
15.5%
Computer Software
12.7%
Financial Services
7.7%
Retail
5.2%
Telecommunications
4.7%
Other
54.1%
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%
Alternatives
Discussions
Should I use with a data mart for a frontend tool that make request on it ?
3 Comments
NM
Hi Mehdi
Can you elaborate your question?
AWS Redshift is a DataBase/Data Warehouse service, which is Ideal for Analytical use cases.
You can...Read more
When can I use Amazon redshift?
3 Comments
PG
Redshift is big data warehousing solution to handle petabytes of data and also for real time decisions. If you want highly optimized data warehousing...Read 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
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.
