Google BigQuery

Google BigQuery

About TrustRadius Scoring
Score 9.0 out of 100
Google BigQuery

Overview

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

Reviewer Sentiment

N/A
Positive ()
N/A
Negative ()
Learn how we calculate reviewer sentiment

Awards

TrustRadius Award Top Rated 2020

Popular Features

View all 6 features

Database scalability (29)

9.8
98%

Automated backups (24)

9.4
94%

Database security provisions (24)

9.2
92%

Monitoring and metrics (25)

8.3
83%

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!

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.2
92%

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

Comparisons

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.8.

Who uses Google BigQuery?

The most common users of Google BigQuery are from Mid-sized Companies (51-1,000 employees) and the Computer Software industry.

Reviews

(1-25 of 29)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
Review Source
An excellent SQL data management tool without having to manage instances or maintain clusters that need to scale. For a startup or organization that wants to implement a data warehouse logic, it is one of the fastest ways to implement, cheapest to maintain and simple to use that I know of in the market.
March 08, 2022

Data Powerhouse

Score 9 out of 10
Vetted Review
Verified User
Review Source
If you are using Google suites like Analytics 360, Big Query can be a very useful tool for storing & querying your data because of its seem less integration within Google environment. Also if your organisation has large set of data and you want fast data processing, then only it makes sense to move to Google BigQuery otherwise there are cheaper alternatives available.
Score 10 out of 10
Vetted Review
Verified User
Review Source
I would say that Google BigQuery are well suited for all scenarios, be it small scale projects or big projects where you have to maintain a huge chunk of data, you will find good budget to go with it. Easy to use for someone who is not well versed with cloud platform too.
Score 10 out of 10
Vetted Review
Verified User
Review Source
BigQuery is an extremely powerful tool to store granular data. We have tables with trillions of rows and BigQuery has proven to be extremely reliable over time. For organizations that require a very reliable datastore, BigQuery is an excellent choice. The price is also very reliable given the amount of data we store.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Google BigQuery is suitable for scenarios where the dataset is large and needs to be analyzed based on real time data. Google BigQuer has been very useful when I was working on the inventory data for the bookstore. At the beginning of semester there was always high demand for school materials, this high demand caused a steady decline in the inventory. Getting updated real time helped us to restock the warehouse beforehand with products in higher demand and thereby led to higher sales.
Score 9 out of 10
Vetted Review
Verified User
Review Source
One of the most important aspects while working with data warehousing solutions and analytics is the ability to handle large datasets. Google BigQuery is the best in business for that particular aspect. It is ridiculously fast while handling large data sets. Another aspect where it is well suited is the ability to integrate it with data visualization tools like Data Studio. It is fast, easy to use, and very reliable. The only aspect where I feel it is less appropriate where you have to pay more of inefficient scripts and that can hamper the growth of the company a bit.
April 26, 2021

BigQuery = Big Win

Score 9 out of 10
Vetted Review
Verified User
Review Source
If you are dealing with very large data sets that require analysis or other manipulation, BigQuery is usually well suited for the task. It also has some built-in ML capabilities that may be of use to some people. If your data set is not very large and is relational in nature, then a more traditional data store is probably all you need, which can likely be used at a lower cost.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Google BigQuery works well for enterprise organizations that have sufficient IT resources to implement its integration and data governance requirements. For example, if an organization is a billion-dollar food distributor, and it wants to run quick queries against large data warehouses to pull correlated sales and marketing reports. So, it can show return on investment driven by training initiatives and marketing campaigns to lift new customer acquisition rates and incremental case purchases. Google BigQuery is less appropriate to use in small businesses where data volume is low, and IT resources are not enough to maintain data quality or run SQL queries. Example: If a company requires to report eCommerce sales from digital-only marketing campaigns where audience size is a few hundred customers, Google BigQuery may not be needed. Instead, Google Analytics or Adobe Analytics will suffice.
Cameron Gable | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We have several hundred terabytes of data and the size of our dataset is exponentially increasing. We needed a data warehouse that is highly scalable. We also serve a user base with several dashboards. BigQuery is great because it integrates nicely with Google Data Studio and other analytics products.
Jose F. Gomez | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
Google BigQuery is an especially powerful tool for teams running a business that collects data in multiple tools and want to have a place to centralize all of the data for process analysis. Teams that want to learn the insights of every aspect of their processes and their performance can store their processes data in Google BigQuery and then create queries and store them as needed then run experiments or test scenarios and measure outcomes easily.
Score 10 out of 10
Vetted Review
Verified User
Review Source
I use it primarily in place of Google Analytics in Tableau since we use Tableau for all of weekly and monthly reporting and dashboards. One of the many advantages is being able to access unfiltered data and unaggregated data. This allows us to accurately capture measures such as unique users across many different time frequencies, which you can only do at the yearly level with Google Analytics.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Google BigQuery is very well suited if your data is large and already in Google Cloud/GCP where the data itself is not simple structured data. It is less suited if you have well-defined data sets that may or may not exist in Google Cloud. Google BigQuery is also less suited if you have to analyze the data on a regular basis since the cost of accessing compute and storage adds up considerably.
Tristan Dobbs | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
Review Source
BigQuery is unlike anything we've used as a big data tool. It is perfectly suited to query large data sets quickly and to store those large data sets for any time use. It's perfect for storing data and using it for reports. Logging data is the perfect application for BigQuery, but transactional data is possible as well.
Score 7 out of 10
Vetted Review
Verified User
Review Source
BigQuery is a huge benefit to companies that work remotely, process large datasets, or need to easily manage those large datasets. It's a powerful tool with cloud storage and the ability to work with large scale datasets. It works well if your monthly usage varies because you can pay for the processing you do- not paying for a minimum that you don't meet. It's not going to be a great option for companies with smaller datasets or who could operate with a less powerful and cheaper system.
Sam Lepak | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
Review Source
I recommend this platform for wide range of customers that have not super tight budget for their application hosting but want to stay away from bunch of low-level details of running and maintenance of application infrastructure. Google BigQuery is easy to use and its interface is very nice, it also has a wide range of servers, which makes its services are excellent. This software has allowed me to easily access my files and share them quickly and efficiently, it also allows other activities while loading and downloading files, therefore saving a lot of time compared to other similar applications.
Evan Laird | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Suited to any company, small or large (as it's extremely scalable and low cost as it scales), that wants or needs to dive into data to make more data-driven decisions or back up decisions with user data. The team should have someone that is well versed in SQL though, as non-technical team members will be a bit lost.
Spencer Baselice | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
BigQuery is well suited for organizations that use a lot of data across lots of teams or departments. It is perfect for those companies who need various data dumps or data storage areas for different parts of the company, where the data storage is flexible and easily accessible for everyone. It is also a cost-effective method from what I understand, so if your company needs to enable teams to have better access to larger amounts of data storage and databases BigQuery is a logical option.
Gaurav Gautam | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
BigQuery's main strength is its ability to process huge volumes of data with lightning speed, and also perform personal detailed analysis on web analytics data or continuous streams of piles of data and then link it directly to data studio.
Score 8 out of 10
Vetted Review
Verified User
Review Source
- If you are using Google Analytics and there is huge data that is getting streamed every day then you must have Big Query and use it for analysis. It is not only helpful for analysis but also for debugging your Google Analytics implementations.
- For analyzing a small dataset you don't need Big Query you can use normal MySQL on your own premises. Analyzing on Un-structured data is not possible with Big Query.
Anatoly Geyfman | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
BigQuery is best of OLAP. It's not a real-time system, so you shouldn't expect it to search through your billion records in 2 seconds. We use it to store raw, unaggregated data. For this use case, it's perfect, since the storage costs are low and the performance is more than good enough. BigQuery is also great for building data pipelines. It has convenient SDK to get data in and out of it, and SQL to marshall the data any way you want.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Google BigQuery is well suited to applications where the data is coming from another Google Cloud product and the data will be used in frequent ad hoc queries. The performance of BigQuery on ad hoc queries makes it a good source for business intelligence applications. Additionally, automating repeated queries and common workflows with Google App Scripts is a good application with BigQuery.
Dmitry Sadovnychyi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
It works well for a big dataset starting from hundreds of GB. I wouldn't recommend using it for people with less than 100 GB in data – except when you expect to grow your dataset in the near future. It's also not really good to directly answer on live requests, it's much better to use it to pre-process some data, store it somewhere else, and serve it from there.