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.7
    87%
  • Automated backups (24)
    8.5
    85%
  • Monitoring and metrics (46)
    8.4
    84%

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

Starting price (does not include set up fee)

  • $6.25 per TiB (after the 1st 1 TiB per month, which is free)
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.4
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.

BigQuery is a fully managed, AI-ready data analytics platform that helps you maximize value from your data and is designed to be multi-engine, multi-format, and multi-cloud.

Store 10 GiB of data and run up to 1 TiB of queries for free per month.


Gemini in BigQuery for an AI-powered assistive experience

BigQuery provides a single, unified workspace that includes a SQL, a notebook and a NL-based canvas interface for data practitioners of various coding skills to simplify analytics workflows from data ingestion and preparation to data exploration and visualization to ML model creation and use. Gemini in BigQuery provides AI-powered assistive and collaboration features including code assist, visual data preparation, and intelligent recommendations that help enhance productivity and optimize costs.


Bring multiple engines to a single copy of data

Serverless Apache Spark is available directly in BigQuery. BigQuery Studio lets users write and execute Spark without exporting data or managing infrastructure. BigQuery metastore provides shared runtime metadata for SQL and open source engines for a unified set of security and governance controls across all engines and storage types. By bringing multiple engines, including SQL, Spark and Python, to a single copy of data and metadata, the solution breaks down data silos.


Built-in machine learning

BigQuery ML provides built-in capabilities to create and run ML models for BigQuery data. It offers a broad range of models for predictions, and access to the latest Gemini models to derive insights from all data types and unlock generative AI tasks such as text summarization, text generation, multimodal embeddings, and vector search. It increases the model development speed by directly applying ML to data and eliminating the need to move data from BigQuery.


Built-in data governance

Data governance is built into BigQuery, including full integration of Dataplex capabilities such as a unified metadata catalog, data quality, lineage, and profiling. Customers can use rich AI-driven metadata search and discovery capabilities for assets including dataset schemas, notebooks and reports, public and commercial dataset listings, and more. BigQuery users can also use governance rules to manage policies on BigQuery object tables.

Google BigQuery Features

Database-as-a-Service Features

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

Google BigQuery Screenshots

Screenshot of Migrating data warehouses to BigQuery - Features a streamlined migration path from Netezza, Oracle, Redshift, Teradata, or Snowflake to BigQuery using the fully managed BigQuery Migration Service.Screenshot of bringing any data into BigQuery - Data files can be uploaded from local sources, Google Drive, or Cloud Storage buckets, using BigQuery Data Transfer Service (DTS), Cloud Data Fusion plugins, by replicating data from relational databases with Datastream for BigQuery, or by leveraging Google's data integration partnerships.Screenshot of generative AI use cases with BigQuery and Gemini models - Data pipelines that blend structured data, unstructured data and generative AI models together can be built to create a new class of analytical applications. BigQuery integrates with Gemini 1.0 Pro using Vertex AI. The Gemini 1.0 Pro model is designed for higher input/output scale and better result quality across a wide range of tasks like text summarization and sentiment analysis. It can be accessed using simple SQL statements or BigQuery’s embedded DataFrame API from right inside the BigQuery console.Screenshot of insights derived from images, documents, and audio files, combined with structured data - Unstructured data represents a large portion of untapped enterprise data. However, it can be challenging to interpret, making it difficult to extract meaningful insights from it. Leveraging the power of BigLake, users can derive insights from images, documents, and audio files using a broad range of AI models including Vertex AI’s vision, document processing, and speech-to-text APIs, open-source TensorFlow Hub models, or custom models.Screenshot of event-driven analysis - Built-in streaming capabilities automatically ingest streaming data and make it immediately available to query. This allows users to make business decisions based on the freshest data. Or Dataflow can be used to enable simplified streaming data pipelines.Screenshot of predicting business outcomes AI/ML - Predictive analytics can be used to streamline operations, boost revenue, and mitigate risk. BigQuery ML democratizes the use of ML by empowering data analysts to build and run models using existing business intelligence tools and spreadsheets.Screenshot of tracking marketing ROI and performance with data and AI - Unifying marketing and business data sources in BigQuery provides a holistic view of the business, and first-party data can be used to deliver personalized and targeting marketing at scale with ML/AI built-in. Looker Studio or Connected Sheets can share these insights.Screenshot of BigQuery data clean rooms for privacy-centric data sharing - Creates a low-trust environment to collaborate in without copying or moving the underlying data right within BigQuery. This is used to perform privacy-enhancing transformations in BigQuery SQL interfaces and monitor usage to detect privacy threats on shared data.

Google BigQuery Video

Demo: Solving business challenges with an end-to-end analysis in BigQuery

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 $6.25.

Snowflake, Amazon Redshift, and Databricks Lakehouse Platform are common alternatives for Google BigQuery.

Reviewers rate Database scalability 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

(247)

Attribute Ratings

Reviews

(1-3 of 3)
Companies can't remove reviews or game the system. Here's why
Richard Atkins | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Data warehousing. Streaming and batch ingest of files and APIs. Implementing business logic, combining data from different sources, reformatting, reporting, and optimization automation
  • Standard SQL
  • Scale
  • RDBMS-like features
  • Python library support
  • Reliability
  • Python library authentication simplification
  • multi-transaction ACID compliance
Well; data warehousing transformation flexible ingestion
Database-as-a-Service (6)
78.33333333333333%
7.8
Automatic software patching
100%
10.0
Database scalability
100%
10.0
Automated backups
100%
10.0
Database security provisions
90%
9.0
Monitoring and metrics
80%
8.0
Automatic host deployment
N/A
N/A
  • Reduced time to market of features compared to legacy warehouse
  • Improved engineer productivity
  • Simplified TCO
  • Improved data security
The web UI, general features, libraries, and integration with other products is continuously improving and already very strong
web UI is easy and convenient. Many RDBMS clients such as aqua data studio, Dbeaver data grid, and others connect. Range of well-documented APIs available. The range of features keeps expanding, increasing similar features to traditional RDBMS such as Oracle and DB2
Requests and escalation are often quickly acted, however usually done through specific individuals instead of teams, therefore continuity may not always be smooth.
50
20
Score 10 out of 10
Vetted Review
Verified User
Used to deploy this solutioning to the client by shifting away from traditional data warehouse to cloud data warehouse. It resolves the issue of transparency in terms of payment per month, utilization and on how to allow user level access to different folders. It also allows for full integration with other Google Cloud Platform's components like Compute Engine and PubSub.
  • Transparency in terms of cost
  • Utilisation of the data warehouse and suggestion on the sizes
  • Easy to use and integration with other components
  • UiUX features can be improved further in terms of navigating from one folder to another
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.
Database-as-a-Service (6)
98.33333333333334%
9.8
Automatic software patching
100%
10.0
Database scalability
100%
10.0
Automated backups
90%
9.0
Database security provisions
100%
10.0
Monitoring and metrics
100%
10.0
Automatic host deployment
100%
10.0
  • Reduced time to integrate from one components to another
  • Reduced the cost for cloud warehousing
  • Ease of use so reduced time to get to use on a daily basis
Google Support members are very helpful in resolving the issues and queries. Any questions or queries will be entertained at a timely manner with professionalism, as well as tips and improvement that can be done for the proposed solutioning. In the case that some functionalities are not present within Google BigQuery, they are more than happy to admit the limitation and would like feedback for improvement.
Easy to use and to integrate. In terms of scalability, the size of the BigQuery can easily scale to suit the need of the process and design. No glaring limitation in terms of use for Google BigQuery based on the use for 1 year, and will continue to feel so after many years due to the support.
Google Support has kindly provide individual support and consultants to assist with the integration work. In the circumstance where the consultants are not present to support with the work, Google Support Helpline will always be available to answer to the queries without having to wait for more than 3 days.
None so far. Very satisfied with the transparency on contract terms and pricing model.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
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 a small company. It works extremely well for my company because it is cloud-based and we do a lot of remote work, so I can access our data and manage things from anywhere. It's a great tool and makes all kinds of data processing and analysis much easier and faster.
  • Cloud storage- always a huge draw for small businesses who may or may not have a bricks-and-mortar office to work from. We can share data easily and access it from anywhere.
  • The user interface is excellent- easy to navigate and conduct whatever specific analyses you want
  • You pay for the data you process, so it's kind of a pay-per-use system. This is awesome for smaller companies who may not need excessive amounts of data processed per month but still need the powerful analytics of a program like BigQuery.
  • Even though the cost is pay-per-use, it's still expensive. This may make the program impractical for companies that won't use it frequently enough or for high-powered processing as it is meant for.
  • Sometimes it is difficult to import data from alternate sources and manage it. The integrations between BQ and other online cloud storage aren't always a smooth transfer.
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.
Database-as-a-Service (6)
91.66666666666666%
9.2
Automatic software patching
80%
8.0
Database scalability
100%
10.0
Automated backups
80%
8.0
Database security provisions
90%
9.0
Monitoring and metrics
100%
10.0
Automatic host deployment
100%
10.0
  • 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.
BigQuery is a little bit difficult to learn at first. The tools are all there but it takes a few hours of practice and trial and error to be comfortable processing a large dataset. It can handle quite a bit and the cloud storage makes those experimental practice hours much easier to do in your spare time. The software is capable of doing a lot, it's just a matter of being patient and learning the ways of BigQuery.
As with any large company, support isn't always easy to get to. There are plenty of online tutorials and they have online guides that aren't too difficult to find. For last minute issues, a call is the best option to figure out what your next step should be. it's not a terrible customer service system, especially if you spend an appropriate amount of time beforehand familiarizing yourself with the system. That'll expedite any further questions you have down the road and make the support a much bigger help.
Return to navigation