Introducing G2.ai, the future of software buying.Try now
Compare Amazon Redshift and Google Cloud BigQuery 
Featured Products
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,208)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.
- G2 reviewers report that Google Cloud BigQuery excels in user satisfaction, boasting a significantly higher overall score compared to Amazon Redshift. Users appreciate its serverless architecture and the ability to focus on SQL without worrying about infrastructure, making data analysis feel smooth and efficient.
- According to verified reviews, Amazon Redshift is recognized for its scalability and ease of implementation. Users highlight its ability to quickly scale up and down, which is particularly beneficial for managing large datasets and ensuring data safeguarding through its multi-zone architecture.
- Reviewers mention that Google Cloud BigQuery's pay-as-you-go model simplifies operations, allowing users to pay only for the storage and compute they use. This flexibility enables experimentation with larger datasets, a feature that many users find invaluable for their data analysis needs.
- Users say that while Amazon Redshift offers a powerful columnar data solution, it sometimes lacks the same level of performance efficiency as BigQuery, particularly when handling billions of queries simultaneously. This can impact the speed of data retrieval for complex queries.
- Reviewers highlight that both platforms provide strong data integration capabilities, but Google Cloud BigQuery stands out with its built-in machine learning tools and AI integration, which enhance its functionality for advanced analytics and data modeling.
- According to recent user feedback, while Amazon Redshift has a solid support rating, Google Cloud BigQuery's support is often described as more responsive and helpful, contributing to a better overall user experience when troubleshooting or seeking assistance.
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
616
Ease of Use
8.7
281
8.7
632
Ease of Setup
8.6
138
8.8
407
Ease of Admin
8.4
128
8.5
224
Quality of Support
8.5
264
8.4
565
Has the product been a good partner in doing business?
8.7
127
8.6
217
Product Direction (% positive)
8.8
252
9.3
605
Features by Category
Management
Not enough data
8.6
121
Not enough data
8.3
119
Functionality
Not enough data
9.0
119
Not enough data
9.1
123
Not enough data
9.0
123
Not enough data
8.9
122
Not enough data
9.3
122
Data Management
8.8
133
|
Verified
8.9
220
|
Verified
8.4
125
|
Verified
8.3
210
|
Verified
8.8
131
|
Verified
8.9
215
|
Verified
8.0
127
|
Verified
8.6
215
|
Verified
7.6
102
|
Verified
8.3
203
|
Verified
8.3
118
|
Verified
8.7
200
|
Verified
Integration
7.9
101
|
Verified
8.5
202
|
Verified
8.7
128
|
Verified
8.6
213
|
Verified
8.6
119
|
Verified
8.6
200
|
Verified
Deployment
8.1
102
7.7
186
|
Verified
8.9
130
|
Verified
9.1
216
|
Verified
Performance
8.9
134
|
Verified
9.1
224
|
Verified
Security
8.7
126
|
Verified
8.7
207
|
Verified
8.8
128
|
Verified
9.1
213
|
Verified
Generative AI
7.3
20
7.6
127
7.2
19
7.8
124
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
78
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
79
Not enough data
8.7
77
Not enough data
8.7
79
Not enough data
8.7
77
Generative AI
Not enough data
7.5
50
Not enough data
7.8
50
Marketing Operations
Not enough data
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
Campaign Activity
Not enough data
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
Agentic AI - Marketing Analytics
Not enough data
8.7
15
Not enough data
9.6
15
Not enough data
8.2
15
Database
Not enough data
8.8
175
Not enough data
8.9
173
Not enough data
8.7
167
Integrations
Not enough data
8.4
136
Not enough data
8.5
133
Platform
Not enough data
8.9
151
Not enough data
8.9
165
Not enough data
8.5
133
Processing
Not enough data
9.2
168
Not enough data
9.1
161
Data Transformation
Not enough data
8.8
283
Not enough data
9.3
293
Connectivity
Not enough data
8.1
251
Not enough data
8.2
249
Not enough data
8.7
278
Not enough data
8.7
269
Operations
Not enough data
8.5
278
Not enough data
8.7
277
Not enough data
8.3
255
Not enough data
8.4
262
Not enough data
8.5
254
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.4%
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
What are the characteristics of redshift?
2 Comments
AK
Redshift is mainly used for Big data and analytics to store the data in columner format. Retrieve the data is very fast and parallel processing also most...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.
