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

BigQuery- A big tool with a lot to offer

7
We use BigQuery to manage large datasets we collect in surveys and in regular work projects. Only one person is in charge of it as we are …
Read full review

Google BigQuery: Slow Learning Curve

6
In our organization, Google BigQuery is for storing very large data which is created within seconds. We log each and every event done by …
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-25 of 27)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Integrate well with google data visualization tools that can save a lot of money on licensing of other tools.
  • Requires basic SQL skills which are transferrable and saves money spent on training.
  • Gives an all out data retrieval and storage service which makes it a lot easier for employees across organization to fetch data.
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Positive - My organization has faced great profits and has trubleshooted many issues before hand because of the realtime data to work on. It keeps the data up to date.
  • Negative - As there are various Google BigQuer proficiency people in the organization. Some very experienced and some novice. It has a negative impact because people who are new write longer and inefficient codes so the company is charged more.
April 26, 2021

BigQuery = Big Win

Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Once up and running, we no longer have to worry about scale and managing infrastructure. Instead of spending our time on our analytics and bringing that value to our customers.
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Google BigQuery has enabled my organization to connect the dots between online marketing campaigns and offline case purchases.
  • Google BigQuery has helped build a big data warehouse with lower cost and IT resources for smaller sales and marketing campaign requirements.
Tristan Dobbs | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
Review Source
  • We've seen a greatly reduced cost in data storage.
  • We have gained the ability to make more immediate data-driven decisions.
  • We have gained the ability to run many more reports and gain insight much faster.
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Big Query helps to analyze web traffic from different channels to optimize our message and conversion paths.
  • We use BigQuery Data Transfer Service for Google Ads to automatically schedule and manage recurring load jobs for Google Ads reporting data.
Sam Lepak | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
Review Source
  • Pricing has been very reasonable for us. The first 10 GB of storage is free each month and costs start at 2 cents per GB per month after that. For example, if you store 1 terabyte (TB) for a month, then the cost would be $20. Streaming data inserts start at 1 cent per 200 megabytes (MBs). The first 1 TB of queries is free, with additional analysis at $5 per TB thereafter. Meta data operations are free.
  • Big Query helps reduce the bar for data analytics, ML and AI. BQ takes care of mundane tasks and streamlines for easy data processing, consumption. The most impressive thing is the ML and AI integration as SQL functions, so the need for moving data around is minimized.
  • The visuals of ML models is very helpful to fine tune training, model building and prediction, etc.
Spencer Baselice | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
  • It helps us to manage and understand the larger breadth of our Search Engine presence using data from our Search Console API. This helps us locate and track issues and improvements.
  • Using BgiQuery also improves the access to multiple types of data that we use for tracking performance and monitoring changes in our competitive position in the SERPs.
  • It allows us a faster, easier way to manage and store large databases without having to host them on a local machine or another cloud.
Anatoly Geyfman | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • We were able to reduce our investment in self-hosted Postgres and move our bigger data assets to BigQuery. Overall, we saved hundreds per month, thousands per year.
  • We are able to search through very large datasets with BQ that were difficult to search with standard Postgres, even on very large servers. This gave us the ability to do ad-hoc data introspection easily.
  • Because we already used Google Storage, it was easy to integrate BQ into our environment.
Alex Andrews | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Google BigQuery has had enormous impact in terms of ROI to our business, as it has allowed us to ease our dependence on our physical servers, which we pay for monthly from another hosting service. We have been able to run multiple enterprise scale data processing applications with almost no investment
  • Since our business is highly client focused, Google Cloud Platform, and BigQuery specifically, has allowed us to get very granular in how our usage should be attributed to different projects, clients, and teams.
  • Plain and simple, I believe the meager investments that we have made in Google BigQuery have paid themselves back hundreds of times over.
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Being server-less, fully managed cloud server, Google BigQuery has a positive impact on the business in terms of amount of setup time and deployment resources needed to analyze a data set.
  • Positive impact on ROI due to reduction in CapEx and OpEx needed to provision a data warehouse upfront.
  • Positive impact on ROI due to no improvement in the speed of analyzing consumer data using Google BigQuery in real-time and proactively take action when/if needed based on the results.
Score 7 out of 10
Vetted Review
Verified User
Review Source
  • BigQuery has been a great benefit for managing large datasets. We collect quite a bit of data in our line of work and it's difficult to find program that can easily manage that as well as have it accessible via cloud storage.
  • The cost is high, even though you only pay for what you use. Ideally the cost would be lower for certain usage ranges but for now, it's difficult for a small company to justify the cost even with such large scale data.
Csaba Toth | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • If BigQuery fits your business needs (see best scenarios) it can yield great ROI.
  • You maybe able to answer questions with ease which would take much more effort with other big data query technologies (HIVE, Spark, ...). You miay pay some costs.
  • Following some best practices (how to construct and limit your queries) can decrease your costs.
Score 6 out of 10
Vetted Review
Verified User
Review Source
  • ROI is very small although it's positive. Still, I am not happy with this product as it took five to six days to understand the flow of the product and how to implement it into our project, whereas other database systems would have taken one to two days.