Skip to main content
TrustRadius
Google BigQuery

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
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 (51)
    8.8
    88%
  • Database security provisions (44)
    8.8
    88%
  • Automated backups (24)
    8.5
    85%
  • Monitoring and metrics (46)
    8.5
    85%

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing

Standard edition

$0.04 / slot hour

Cloud

Enterprise edition

$0.06 / slot hour

Cloud

Enterprise Plus edition

$0.10 / slot hour

Cloud

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://cloud.google.com/bigquery/prici…

Offerings

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

Product Demos

Lesson#6 - BigQuery for beginners| Analyzing data in google bigquery | Step by step tutorial (2020)

YouTube

How to get started with BigQuery

YouTube

BigQuery, IPython, Pandas and R for data science, starring Pearson

YouTube

Google BigQuery Demo

YouTube

Google BigQuery introduction by Jordan Tigani

YouTube
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.5
Avg 8.7
Return to navigation

Product Details

What is Google BigQuery?

Google BigQuery is a serverless, multicloud data warehouse that simplifies the process of working with all types of data. At the core of Google’s data cloud, BigQuery can be used to simplify data integration and securely scale analytics, share rich data experiences with built-in business intelligence, and train and deploy ML models with a simple SQL interface, helping to make an organization’s operations more data-driven.

Google BigQuery Features

Database-as-a-Service Features

  • Supported: Database scalability
  • Supported: Database security provisions
  • Supported: Monitoring and metrics

Additional Features

  • Supported: Unified experience for all analytics users
  • Supported: Duet AI in BigQuery
  • Supported: Flexibility, predictable pricing, and best price performance
  • Supported: Built-in machine learning
  • Supported: Analyze and share data across clouds
  • Supported: Real-time analytics with streaming data pipelines
  • Supported: Unify, manage, and govern all types of data
  • Supported: Share insights with built-in business intelligence
  • Supported: Geospatial analysis with BigQuery
  • Supported: Real-time change data capture and replication

Google BigQuery Competitors

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.

Google BigQuery starts at $0.

Snowflake and Amazon Redshift are common alternatives for Google BigQuery.

Reviewers rate Database scalability and Database security provisions highest, with a score of 8.8.

The most common users of Google BigQuery are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(248)

Attribute Ratings

Reviews

(1-25 of 51)
Companies can't remove reviews or game the system. Here's why
Rajender Singh | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are analyzing large volumes of data generated by IoT devices to derive actionable insights and improve decision-making and for monitoring purpose while sitting from different places around the globe. Google BigQuery is helping us in setting up automation of gear manufacturing process in factories so as to reduce human effort.

Score 8 out of 10
Vetted Review
Verified User
Incentivized
My company, Randstad, uses BigQuery as our data warehouse to store all our lead information and marketing metrics. It pulls numbers from various sources and then creates master data sources, which we use for the performance dashboards we present to internal stakeholders. More recently, we have been using Big Query to host our historical data from Google Analytics.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
The scope of my use case is data governance relevant. My organization uses Google big query as the primary tool for storing, reading, updating and analyzing data. Due to the big size of the organization, we have an increasing number of data consumers and my specific use case is to provide a data control panel to make sure the data is being used properly according to the data Governance policies.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use BigQuery majorly for two purposes. Our data engineering team develops trends based on collected data over BigQuery. That helps us strategize our feature rollouts. The second use case where we make use of BigQuery is in our tests dashboard. We collect test success and failure data and use BigQuery to categorise different failures, calculate failure rates and show trend for errors after weekly releases.
Nir Levy | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are using Google BigQuery to store and analyze our big-data and analytics for one of our major projects. We stream different types of data from different sources into BQ and use complex queries to join data from different sources. Data can be queried both programmatically from our application, or displayed using tools like Looker Data Studio.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We have used Google's big query to store and analyze vast amounts of data. In today's time, every organization requires real-time insights from the data. BigQuery can be Integrated with popular BI tools to visualize data and generate actionable insights, aiding in department decision-making processes. With BigQuery, we have a centralized repository for all organizational data, facilitating easy access for analysis and reporting.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
As a supplement solution to the main enterprise systems for reporting, it is mostly used for the R&D department. The aim was to query rather diverse and semi-structured data from various systems. Some of the sources were wide, some deep and a few were both. Other tools for storing and querying were tried as well.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Due to its lower cost, we use BigQuery as our primary database to store most of our data. We also use BigQuery to run periodic analytical tasks. We mainly use it for our WebSights product which collects and stores many user demographics and enriches IP traffic.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Google BigQuery is being used in unlocking real-time user data and boost data-processing power to perform more extensive business analytics. Along with other complimenting products like Dataplex, it has become a solid warehouse for the whole organization to make data-backed decisions.
Score 6 out of 10
Vetted Review
Verified User
Incentivized
We use Google BigQuery in conjunction with Bloomreach, this allows us to query the back end of the data without having to use the front end. The tool is fast to run queries and allows us to move the data to our other Data Warehouse environments quickly with little effort.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Today, every company must evolve and enter AI data mining. We have decided to use Google BigQuery as our solution to explore/explode all the data we have archived in our different database environments. In our case, the healthcare area is very important and complex. A lot of data moves every day, and Google BigQuery helps us manipulate large amounts of it.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We use Google BigQuery as a data warehouse to pull data from analytics platforms such as Google Analytics. This allows us to create various tables containing the exact data various parts of the business need. We can then create dashboards for end-users internally. It especially answers our needs in terms of user behaviour and engagement. Our data capabilities are reinforced and much more scalable.
Deep Mukherji | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We deal with massive datasets – customer transactions, website logs, sensor data from our products – all running into terabytes. Google BigQuery acts as our central data warehouse and ingests data from various sources, like CRM systems, marketing tools and also from internal applications. It's not just the marketing team or data scientists who leverage it. Sales uses it for customer segmentation and churn analysis. The product team relies on it for user behaviour analysis and identifying feature adoption trends. The speed of Google BigQuery is mind-blowing. I can run complex SQL queries on massive datasets and get results almost instantly.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Analytics Powerhouse. Google BigQuery is the best solution if you want to find trends from your past data. It is a Data warehouse which has SQL and ML capabilities. We have been using Google BigQuery for analyzing our customers billing data and creating dashboards in Looker Studio which can be used by our Sales teams.
Ilyas Bakirov | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We tried to use Google BigQuery to analyze, perform and build various custom queries to our large set of geological historical data. To solve our needs in geological analysis of huge data, we looked around at what tools would allow us to optimally perform analytical work without capital expensenses and learning new tool.
Ömer Perçin | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are analyzing loads of financial data and therefore had to find a solution which can handle the amount of data we have in our organization. The data insights generated by reports based on Google BigQuery are very valuable to all stakeholders involved. Google BigQuery helped a lot in our use case.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are using Google BigQuery to store all events data of our app and Since our events data are recorded every second wise so it's a large data set of events that are easily handled by Google BigQuery since Google BigQuery has minimal charges for storage and mainly it will charge for running the query inside the Google BigQuery so it will be very easy for us to store a large database in Google BigQuery.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Our business uses Google BigQuery to analyze data from Google Analytics (both UA and GA4). The platform has an easy to understand layout that has improved a lot over the years. One of the key features that makes it user friendly is the ability to have side-by-side tabs of different code and output. This makes it easy to compare multiple versions of data. This platform is used to help us track are key web vitals that inform on us our sites performance. Because we have multiple different key variables that are stored in different locations, we often need to join data tables together or compare data between the different locations.
March 12, 2024

Great Data Warehouse.

Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use BigQuery as our data warehouse to store a large part of our data. We also use BigQuery to normalize, tie together, and prepare data for data visualization. It allows us to tether disparate data sources to create analyzable and comprehensive KPIs at granular and high-level layers.
March 12, 2024

Great platform

Score 9 out of 10
Vetted Review
Verified User
Incentivized
Google BigQuery serves as our essential PaaS tool for streamlined data management and analysis. As a serverless solution, it offers automatic scaling, eliminating infrastructure hassles. Leveraging its advanced capabilities, we efficiently process large datasets through SQL queries. This empowers our organization with rapid, insightful decision-making, fostering a dynamic, data-driven approach that enhances overall operational efficiency and strategic planning.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are the reseller of Google Analytics and with Google Analytics premium you get Big Query. You get 500$ credit to use in Big Query. Big Query is a great tool to get unsampled reports, that can be further used for different analysis also to build products on top of it. Big Query can help you to analyze user journey, enhanced eCommerce data for creating remarketing audience. You just need to know SQL and you can use Big Query to get whatever data you want. Big Query can be further utilized for your own purpose, you can upload your CRM data and map with Google Analytics data.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
My organization is primarily concerned with training individuals to use store and analyze large amounts of data in a manner that is fast and accurate. Google BigQuery makes it possible to use the Cloud's infrastructure (hardware and software) to accomplish its data analysis goals. Being able to pay for the time and space that is utilized offers significant cost savings, especially for smaller (and mid-size) businesses and those that do not possess adequate resources for establishing a high-capacity infrastructure.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Google BigQuery allows querying multiple datasets within seconds using Sql. It also helps optimise queries to get results quickly.We can preview data without incurring costs. Google BigQuery is a fully managed, serverless, super fast data warehouse with no equivalent in the cloud space. It also creates graph using the data to help generate insights and view trends.
Lee L Kennedy | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Google BigQuery to pull marketing data into a warehouse, run queries on the data to transform it into a more usable form, and then use the resulting tables as data sources for marketing reporting platforms. The problem it addresses is our need for a comprehensive data warehouse where we can store all our business and marketing data so that we can visualize and report on it later on.
December 19, 2022

Google BigQuery is ok!

Tia Jones | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Google Big Query was a contender for our proprietary database to be used as the cloud database to predict scoring models. We use machine learning to predict if someone is going to default on their loan, and use machine learning to determine how much money someone is eligible for. Google Big Query was an option considered for managing this data.
Return to navigation