TrustRadius: an HG Insights company

Google BigQuery vs. Amazon Redshift

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Google BigQuery

    Score8.4 out of 10
    N/AGoogle's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.

    $6.25

    per TiB (after the 1st 1 TiB per month, which is free)

    Amazon Redshift

    Score9 out of 10
    N/AAmazon Redshift is a hosted data warehouse solution, from Amazon Web Services.

    $0.24

    per GB per month

    Pricing
    Google BigQueryAmazon Redshift
    Editions & Modules
    Standard edition
    $0.04 / slot hour
    Enterprise edition
    $0.06 / slot hour
    Enterprise Plus edition
    $0.10 / slot hour
    Redshift Managed Storage
    $0.24
    per GB per month
    Current Generation
    $0.25 - $13.04
    per hour
    Previous Generation
    $0.25 - $4.08
    per hour
    Redshift Spectrum
    $5.00
    per terabyte of data scanned
    Offerings
    Pricing Offerings
    Google BigQueryAmazon Redshift
    Free Trial
    YesNo
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Google BigQueryAmazon Redshift
    Considered Both Products
    Google
    Chose Google BigQuery
    Google BigQuery's main advantage over its direct competitors (Amazon Redshift and Azure Synapse) is that it is widely supported by non-Google software, while the others rely heavily on their own cloud ecosystems.
    Incentivized
    Chose Google BigQuery
    Amazon Redshift was a likely alternative we were considering , but it needs to be provisioned on cluster and nodes, which increases infrastructure management, whereas Google BigQuery is serverless, so no infra management :) Also, I remember when comparing them we did found out …
    Incentivized
    Chose Google BigQuery
    I personally find it by far simpler than Amazon Redshift due it's onboarding seamlessness. For a quick start and simplify tye access to read the data big query provide better user experience and a smoother user interface. More importantly, the fact that Big Query can be easily …
    Incentivized
    Chose Google BigQuery
    Google BigQuery needs minimal setup to get it up and running while Amazon Redshift and Oracle Analytics Cloud need moderate expertise and time to load a data set and run a query. Hadoop (open source) and its commercial version Cloudera do not provide a full out of the box …
    Incentivized
    Chose Google BigQuery
    Compared to every other analytics DB solution I've used, Google BigQuery was by far the easiest to set up and maintain, and scale.
    The price was also much lower for our use case (internal data analysis).
    Incentivized
    Chose Google BigQuery
    We actually use Snowflake and BigQuery in tandem because they both currently meet various needs. Redshift, however, has barely been used since our migration away from it. In the case of both Snowflake and BigQuery, they beat Redshift by a long shot. The main reasons are their …
    Incentivized
    Chose Google BigQuery
    Google BigQuery is cheaper and much faster as compared to both. While as compared to Snowflake , we tested it was faster and cheaper by 30%, that is after Snowflake tweaked their environment, if not for that it would have been 90% cheaper than Snowflake. Redshift is not easy …
    Incentivized
    Chose Google BigQuery
    Its same as compared to Big query. We go with big query because of clients requirements in project.
    Incentivized
    Chose Google BigQuery
    There are some areas in which this product is better while there are some in which others do better. It's not like Google BigQuery surpasses them in every metric. For a holistic view, I will say we use this because of - scalability, performance, ease of use, and seamless …
    Incentivized
    Chose Google BigQuery
    Compared to SingleStore, BigQuery has a big advantage of being completely serverless, and without practical limitations.

    Compared to RedShift, we found the cost model to be more fitted to our needs.
    Incentivized
    Chose Google BigQuery
    BigQuery can automatically scale to accommodate the data and query load, providing potentially unlimited scalability. At the same time, Redshift requires manual scaling efforts to increase or decrease capacity, which might affect performance during scaling operations.
    Incentivized
    Chose Google BigQuery
    Google BigQuery i would say is better to use than AWS Redshift but not SQL products but this could be due to being more experience in Microsoft and AWS products. It would be really nice if it could use standard SQL server coding rather than having to learn another dialect of …
    Incentivized
    Chose Google BigQuery
    Cost is the important factor for us compared with all of the other tools Google BigQuery stands top among all of them which charges very minimal charges for storage against all the apps that we have liked the most additionally, we can do query on our data, and can build …
    Incentivized
    Chose Google BigQuery
    I was already familiar with the Google Cloud Platform environment, and I was better equipped with the standard SQL language. Some of the syntax does not translate well to Redshift. It also seemed like many data source integrations relevant to our business were easier and more …
    Incentivized
    Chose Google BigQuery
    We based our analysis primarily on [BigQuery vs. Redshift vs. Athena] and BigQuery proved to be the best solution for us.
    Incentivized
    Chose Google BigQuery
    Both BigQuery and Redshift are two comparable fully managed petabyte-scale cloud data warehouses. They’re similar in many ways, but you should consider their unique features and how they can contribute to an organization’s data analytics infrastructure. When considering which …
    Incentivized
    Chose Google BigQuery
    Google BigQuery integrates seamlessly with Web Analytics data compared to the Azure cloud.
    Google BigQuery integrates natively with different digital media platforms compared to Azure and AWs.
    Incentivized
    Chose Google BigQuery
    We liked BQ because the cost of it is only dependent on the amount of data you store (and there are tiers of data access) and how much you search. For us, it is significantly less expensive to run BQ than an equivalent hosted RDBMS. Because most of our data pipelines are …
    Incentivized
    Chose Google BigQuery
    BigQuery by far the best solution in all angles compared to other ones: Especially scalability, ease of use, performance and there is no need to manage any cluster of servers. Also it's ABSOLUTELY pay as you go! No one in market currently provide such service that can compete …
    Incentivized
    Chose Google BigQuery
    Google BigQuery is the best among the ones we evaluated. It works really well with the Google Cloud workloads and comes with exceptional security controls. It can be combined easily with lots of products that Google Cloud has. It is a real game-changer.
    Incentivized
    Amazon AWS
    Chose Amazon Redshift
    Amazon Redshift, BigQuery, and Snowflake are all fully managed data warehouse services that are designed to handle large volumes of structured data and support business intelligence and analytics efforts. However, Amazon Redshift has the upper hand with its cost-effective …
    Incentivized
    Chose Amazon Redshift
    Biggest advantage of Amazon Redshift is it's part of the aws ecosystem. When tuned well it is also very cheap compared to something like Snowflake. And compared to spark or databricks, Amazon Redshift is a solid warehouse that's well suited for tabular data. We use it for user …
    Incentivized
    Chose Amazon Redshift
    We evaluated [Amazon] Redshift vs BigQuery vs Amazon EMR, back in 2014.
    Back then BigQuery cost was slightly higher than that of [Amazon] Redshift price structure.
    Amazon EMR, needs lots more management (Admin tasks) and EMR is designed to be ephemeral and not designed to be a …
    Incentivized
    Chose Amazon Redshift
    Amazon Redshift supports multiple data formats including multiple structured data formats. And it is easy to implement a cluster if you do not have knowledge of data lake solution. Also when you do not need a lot of resources, you can just scale down so you do not have to spend …
    Incentivized
    Chose Amazon Redshift
    The best advantage for us was the easy way to integrate our current solution in AWS to Amazon Redshift.
    Incentivized
    Chose Amazon Redshift
    As our applications are hosted on AWS service, Redshift is the best option for us. Also, it provide a near to real-time performance on limited datasets and less complex queries. High availability is the major concern for any growing business and AWS is the best option for this. …
    Incentivized
    Chose Amazon Redshift
    No comment on this.
    Incentivized
    Chose Amazon Redshift
    Most of our stack is on AWS, so while Snowflake and BigQuery was a viable option from a performance perspective, it was easier to integrate with RedShift. We considered hosting SQL Server on AWS or using Amazon RDS (Postgres or MySQL), however, the self-service aspect of …
    Incentivized
    Chose Amazon Redshift
    At the time of evaluation, BigQuery didn't have full SQL support. SQL support has since been added, but I'm not sure if it supports full ANSI SQL.
    Incentivized
    Chose Amazon Redshift

    Than Vertica: Redshift is cheaper and AWS integrated (which was a plus because the whole company was on AWS).

    Than BigQuery: Redshift has a standard SQL interface, though recently I heard good things about BigQuery and would try it out again.

    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    No answers on this topic
    Delivers good value for the price
    No answers on this topic
    No answers on this topic
    Happy with the feature set
    No answers on this topic
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    Features
    Google BigQueryAmazon Redshift
    Database-as-a-Service
    Comparison of Database-as-a-Service features of Google BigQuery and Amazon Redshift
    Feature
    Google BigQuery
    8.4
    71 Ratings
    Amazon Redshift
    -
    Ratings
    Automatic software patching8.017 Ratings00 Ratings
    Database scalability9.270 Ratings00 Ratings
    Automated backups8.524 Ratings00 Ratings
    Database security provisions8.664 Ratings00 Ratings
    Monitoring and metrics8.066 Ratings00 Ratings
    Automatic host deployment8.013 Ratings00 Ratings
    User Ratings
    Google BigQueryAmazon Redshift
    Likelihood to Recommend
    8.6
    (71 ratings)
    9.0
    (38 ratings)
    Likelihood to Renew
    8.1
    (3 ratings)
    -
    (0 ratings)
    Usability
    7.7
    (5 ratings)
    9.0
    (10 ratings)
    Support Rating
    7.3
    (10 ratings)
    9.0
    (7 ratings)
    Contract Terms and Pricing Model
    10.0
    (1 ratings)
    10.0
    (1 ratings)
    Professional Services
    8.2
    (2 ratings)
    -
    (0 ratings)