Google BigQuery

Overview

Reviews

Quit Worrying, Start Using BigQuery

10
Used to deploy this solutioning to the client by shifting away from traditional data warehouse to cloud data warehouse. It resolves the …
Read full review

BigQuery = Big Win

9
BigQuery (along with Airflow) has become a critical part of our technology stack. It is being used to support the ingestion of large …
Read full review

A Robust Tool for Big Data Analysis

8
Google BigQuery is being used to analyze click-stream data-set in conjunction with structured data-set. It is being used in the sales and …
Read full review

Popular Features

View all 6 features

Database scalability (27)

9.9
99%

Automated backups (22)

9.7
97%

Database security provisions (22)

9.7
97%

Monitoring and metrics (23)

8.6
86%

Reviewer Pros & Cons

View all pros & cons

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

Features Scorecard

Database-as-a-Service

9.6
96%

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 TypesSaaS
Operating SystemsUnspecified
Mobile ApplicationNo

Alternatives

View all alternatives

Frequently Asked Questions

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.

What is Google BigQuery's best feature?

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

Who uses Google BigQuery?

The most common users of Google BigQuery are from Mid-size Companies and the Computer Software industry.

Reviews

(1-21 of 21)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
April 26, 2021

BigQuery = Big Win

Score 9 out of 10
Vetted Review
Verified User
Review Source
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 8 out of 10
Vetted Review
Verified User
Review Source
Google BigQuery bridges the gap between online or click-stream and offline transactional or customer data. So, it acts as a big data tool that enables the correlation between digital analytics such as ad clicks or impressions and business intelligence data such as invoice sales. While traditional web analytics tools such as Google or Adobe Analytics focus on collecting and analyzing online behavioral metrics, Google BigQuery focuses on so much more. Including visits, page views, or time spent on a landing page and have no insights on customer activity happening in a physical world like a brick and mortar store or distribution center. Hence, I recommended my organization to leverage Google BigQuery and get a 360-degree view of our customers.
Tristan Dobbs | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
Review Source
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.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Sam Lepak | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
Review Source
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
Review Source
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
Review Source
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
Review Source
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
Review Source
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.)
Csaba Toth | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Reza Qorbani | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.