- Home
- ...
- Data Warehouse Solutions
- Amazon Redshift
- Google Cloud BigQuery
- Amazon Redshift-vs-Google Cloud BigQuery
Compare Amazon Redshift and Google Cloud BigQuery 
At a Glance
Market Segments
Enterprise (39.8% of reviews)
Enterprise (39.9% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
Free
Amazon Redshift
Star Rating
(399)4.3 out of 5
Market Segments
Enterprise (39.8% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plansGoogle Cloud BigQuery
Star Rating
(1,090)4.5 out of 5
Market Segments
Enterprise (39.9% of reviews)
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 comprehensive.
- 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 very large workloads.
- 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.
- Reviewers mention that Google Cloud BigQuery's data security features, scoring 9.1, are robust, including strong encryption and role-based authorization, while Amazon Redshift, with a score of 8.8, is effective but has received feedback about needing more granular security controls.
- Users say that Google Cloud BigQuery's auto recovery feature, scoring 8.6, provides peace of mind with its automated backup processes, while Amazon Redshift's score of 8.2 indicates that users have experienced some challenges with recovery options during outages.
Featured Products
Sponsored
Help Desk Migration Services
(166)
Data Warehouse
Visit Website
Sponsored
Guidewheel
(8)
Data Warehouse
Visit Website
Sponsored
Reaktion
(2)
Data Warehouse
Visit Website
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
280
8.8
510
Ease of Use
8.7
281
8.7
520
Ease of Setup
8.6
135
8.6
281
Ease of Admin
8.5
130
8.6
197
Quality of Support
8.5
263
8.3
467
Has the product been a good partner in doing business?
8.7
129
8.7
190
Product Direction (% positive)
8.9
253
9.3
498
Features by Category
Management
Not enough data
8.5
57
Not enough data
8.2
55
Functionality
Not enough data
8.8
56
Not enough data
9.0
58
Not enough data
8.9
58
Not enough data
8.9
59
Not enough data
9.3
58
Data Management
8.8
129
|
Verified
8.9
131
|
Verified
8.4
121
|
Verified
8.2
124
|
Verified
8.8
127
|
Verified
8.8
128
|
Verified
8.1
123
|
Verified
8.5
124
|
Verified
7.7
98
|
Verified
8.2
113
|
Verified
8.3
114
|
Verified
8.7
115
|
Verified
Integration
7.9
97
|
Verified
8.5
114
|
Verified
8.6
124
|
Verified
8.6
126
|
Verified
8.6
115
|
Verified
8.6
114
|
Verified
Deployment
8.1
98
7.8
102
|
Verified
8.9
126
|
Verified
9.1
125
|
Verified
Performance
8.9
130
|
Verified
9.1
129
|
Verified
Security
8.7
122
|
Verified
8.8
121
|
Verified
8.8
124
|
Verified
9.1
126
|
Verified
Generative AI
Feature Not Available
Feature Not Available
Feature Not Available
Feature Not Available
Storage
8.4
50
8.9
49
8.4
53
8.8
48
Availability
8.7
44
8.6
42
8.2
47
8.6
45
8.4
45
8.5
47
Performance
8.3
45
8.7
45
Security
8.7
44
8.5
49
8.5
49
8.6
48
8.1
44
8.4
47
8.6
45
8.6
43
Support
8.1
40
8.7
45
8.4
44
8.8
43
Centralized computation
Not enough data
8.8
7
Localized computation
Not enough data
8.6
7
Statistical Tool
Not enough data
8.6
45
Not enough data
8.9
47
Not enough data
8.9
46
Data Analysis
Not enough data
9.2
45
Not enough data
9.1
46
Decision Making
Not enough data
8.8
47
Not enough data
8.6
46
Not enough data
8.5
47
Not enough data
8.5
45
Generative AI
Not enough data
Feature Not Available
Not enough data
Feature Not Available
Marketing Operations
Not enough data
8.8
45
Not enough data
9.0
43
Not enough data
9.0
44
Not enough data
9.4
45
Not enough data
8.9
42
Not enough data
8.5
42
Campaign Activity
Not enough data
9.0
47
Not enough data
9.4
46
Not enough data
8.6
43
Not enough data
9.1
41
Not enough data
8.9
43
Not enough data
9.1
44
Database
Not enough data
8.6
122
Not enough data
8.7
120
Not enough data
8.5
114
Integrations
Not enough data
8.0
85
Not enough data
8.4
81
Platform
Not enough data
8.7
98
Not enough data
8.7
113
Not enough data
8.4
81
Processing
Not enough data
9.2
114
Not enough data
9.0
109
Data Transformation
Not enough data
8.8
209
Not enough data
9.3
216
Connectivity
Not enough data
8.1
179
Not enough data
8.2
178
Not enough data
8.7
205
Not enough data
8.8
197
Operations
Not enough data
8.5
207
Not enough data
8.7
203
Not enough data
8.5
183
Not enough data
8.4
190
Not enough data
8.5
181
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.1%
Computer Software
12.4%
Financial Services
8.0%
Retail
5.2%
Telecommunications
4.7%
Other
54.7%
Information Technology and Services
14.0%
Computer Software
13.2%
Retail
7.7%
Financial Services
7.2%
Marketing and Advertising
5.4%
Other
52.5%
Most Helpful Reviews
Amazon Redshift
Most Helpful Favorable Review
Mehdi C.
Verified User in Computer Software
It is fast, we can use it concurrently and we can use SQL over it so we don't have to learn a new language. The Redshift dashboard allow us to cancel request that take too much ressources. We can optimize to allow the request to run faster (with indexing)...
Most Helpful Critical Review
Verified User in Computer Software
It's only on AWS. That's why I can't really recommend this product unless you know you're going to stay on AWS forever. It really offers no differentiation from any other noSQL store and in fact has less features and reliability over most of the tried and...
Google Cloud BigQuery
Most Helpful Favorable Review
Verified User in Information Technology and Services
Bigquery is one of the best database management system that I have used, we can add any number of projects to bigquery and store the data here. The best thing that I like is the console through which we can query the projects data. The data gets updated in...
Most Helpful Critical Review
Verified User in Farming
not supporting lot of other datatypes and not having constraints / primary keys
Mehdi C.
Verified User in Computer Software
It is fast, we can use it concurrently and we can use SQL over it so we don't have to learn a new language. The Redshift dashboard allow us to cancel request that take too much ressources. We can optimize to allow the request to run faster (with indexing)...
Verified User in Information Technology and Services
Bigquery is one of the best database management system that I have used, we can add any number of projects to bigquery and store the data here. The best thing that I like is the console through which we can query the projects data. The data gets updated in...
Verified User in Computer Software
It's only on AWS. That's why I can't really recommend this product unless you know you're going to stay on AWS forever. It really offers no differentiation from any other noSQL store and in fact has less features and reliability over most of the tried and...
Verified User in Farming
not supporting lot of other datatypes and not having constraints / primary keys
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 2.5 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.
or continue with
Gmail.com addresses not permitted. A business domain using Google is allowed.
By proceeding, you agree to our Terms of Use and Privacy Policy
