Google BigQuery

Google BigQuery

Score 8.8 out of 10
Google BigQuery

Overview

What is Google BigQuery?

Google's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.
Read more

Recent Reviews

BigQuery = Big Win

9 out of 10
April 26, 2021
BigQuery (along with Airflow) has become a critical part of our technology stack. It is being used to support the ingestion of large …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 6 features
  • Database scalability (30)
    9.4
    94%
  • Database security provisions (24)
    9.2
    92%
  • Automated backups (24)
    9.0
    90%
  • Monitoring and metrics (26)
    7.9
    79%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Google BigQuery, and make your voice heard!

Return to navigation

Pricing

View all pricing

Queries (Hourly Flex Slots)

$4

Cloud
per 100 slots

Queries (On-Demand)

$5

Cloud
per TB

Queries (Annual Flat Rate)

$1,700

Cloud
per 100 slots

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services
Return to navigation

Features

Database-as-a-Service

Database as a Service (DBaaS) software, sometimes referred to as cloud database software, is the delivery of database services ocer the Internet as a service

8.9Avg 8.7
Return to navigation

Product Details

What is Google BigQuery?

Google's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.

Google BigQuery Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Google's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.

Reviewers rate Database scalability highest, with a score of 9.4.

The most common users of Google BigQuery are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews

(1-23 of 23)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
Google BigQuery manages data like no one else. The light speed of running queries makes it a one stop solution. The editor and query builder also have a highly intuitive interface that makes it easy to build new queries fast. Google BigQuery can easily be integrated with other google products like gmail and drive allowing the team to get real time updates and actionables.
December 19, 2022

Google BigQuery is ok!

Tia Jones | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Treasure Data is more for the marketer rather than a developer audience, so depending on who your main users will be for the machine learning you can decide which tool is better. In our case we went with Treasure Data because it was more for a marketer and less for the developer side.
Score 10 out of 10
Vetted Review
Verified User
BigQuery has a simpler and more intuitive user experience (as is the case with most of its products) compared to AWS, which has a more technical and complex profile, so it was the first tool we used. It's still my go-to option for handling SQL queries, though it doesn't detract from Athenas if the rest of the infrastructure is on AWS.
Score 10 out of 10
Vetted Review
Verified User
At my previous organization we used server based SQL server. There were days when the server was down and we couldn't work or access the data. This caused multiple reports and processes which were fed from the server to fail. Google BigQuery doesn't have such problems.
Score 9 out of 10
Vetted Review
Verified User
I have used Snowflake and DataGrip for data retrieval as well as Google BigQuery and can say that all these tools compete for head to head. It is very difficult to say which is better than the other but some features provided by Google BigQuery give it an edge over the others. For example, the reliability of Google is unmatchable by others. One thing that I really like is the ability to integrate Data Studio so easily with Google BigQuery.
April 26, 2021

BigQuery = Big Win

Score 9 out of 10
Vetted Review
Verified User
We selected BigQuery since we were already making use of many other offerings within the Google Cloud Platform and it made sense to stay within that eco-system. Of course, we made sure it met our needs and was cost-effective, and when it did we didn't seriously consider an alternative from another vendor.
Score 10 out of 10
Vetted Review
Verified User
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 one to use, it is best to take advantage their free trial periods to run your tests. This way you'll be able to use your own results as well as compare them to third party benchmarks that closely make your own business, in order to determine the best cloud data warehouse.
Score 8 out of 10
Vetted Review
Verified User
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 solution for data warehousing and need additional components and installs. Databricks is a smaller vendor and does not come into picture if you are already an Oracle or a Google shop (=using their cloud, DB, et al.)
Tristan Dobbs | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
BigQuery is the first product we've seen of it's kind. Nothing seems to compare to the speed we get and the amount of data that we can fit into BigQuery. Data views are possible and recommended with basic data visualisation tools, but you may also choose to use something with a data layer for visualisation to make the most of your data.
Sam Lepak | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
Google's Firebase isn't a competitor but we had to use Google's BigQuery because Google's Firebase's database is limited compared to Google's BigQuery. Linking your Firebase project to BigQuery lets you access your raw, unsampled event data along with all of your parameters and user properties. Highly recommend connecting the two if you have a mobile app.
Evan Laird | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Firebase is not a competitor, necessarily, of BigQuery, but its integration with it allows for a greater deep dive into our Firebase data. The only reason we needed to start using BigQuery was that Firebase didn't give us the locational data that we need. Because of the easy integration with Firebase, we didn't look at any other services.
Spencer Baselice | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
BigQuery is better at storing and handling large amounts of data than Knime. Knime is locally run and does not have the ability to handle massive databases like BigQuery and importing from multiple sources for multiple teams would be impossible, that is not really the function of Knime anyhow. Knime is far better at manipulating data and creating reports. I use Knime with BigQuery to create reports, and do many data tasks like Keyword Selection, analysis and other related things.
Anatoly Geyfman | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
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 automated, and, we only need to do ad-hoc queries irregularly, BQ fit our criteria very well.
Score 8 out of 10
Vetted Review
Verified User
Other locally hosted solutions are capable of providing the required level of performance, but the administration requirements are significantly more involved than with BigQuery. Additionally, there are capacity and availability concerns with locally hosted platforms that are a concern when working with data used for digital marketing analysis and ad performance optimization.
Reza Qorbani | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
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 with Google BigQuery. The closest was Snowflake and in some cases like supporting ANSI SQL it even better than BigQuery. But at end of the day, BigQuery wins on cost and performance.
Csaba Toth | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Spinning up, provisioning, maintaining and debugging a Hadoop solution can be non-trivial, painful. I'm talking about both GCE based or HDInsight clusters. It requires expertise (+ employee hire, costs). With BigQuery if someone has a good SQL knowledge (and maybe a little programming), can already start to test and develop. All of the infrastructure and platform services are taken care of. Google BigQuery is a magnitudes simpler to use than Hadoop, but you have to evaluate the costs. BigQuery billing is dependent on your data size and how much data your query touches.
Return to navigation