BigQuery 

What is BigQuery?

BigQuery is a serverless data warehouse for analytics that makes it possible to store and query massive amounts of data in seconds. Where on-premise SQL queries could take hours to run, BigQuery makes it possible to do this in seconds using the power of Google's infrastructure.

This fully managed enterprise data warehouse supports analytics over petabyte-scale data. It delivers high-speed analysis of large datasets without requiring investments in onsite infrastructure or database administrators.

BigQuery scales its use of hardware up or down to maximise performance of each query, adding and removing compute and storage resources as required. Google BigQuery, part of the Google Cloud Platform, is designed to streamline big data analysis and storage, while removing the overhead and complexity of maintaining onsite hardware and administration resources. 

Google Cloud Platform

The advantages of BigQuery

Scalable

Scale up to petabytes or down to kilobytes depending on your size, performance, and cost requirements.

Speed

Ingest, query, and export PB-sized datasets with impressive speeds using the Google Cloud Platform as the underlying cloud infrastructure.

Reliability

Ensure always-on availability and constant uptime running on the Google Cloud Platform with geo- replication across Google data centres.

Security

Protect and control access to encrypted projects and datasets through Google’s cloud-wide identity and access management (IAM).

Simplicity

Complete all major tasks related to data warehouse analytics through an intuitive interface without the hassle of managing the infrastructure.

Cost Optimisation

Predict costs with transparent flat rate and/or pay-as-you-go pricing. Discover more: BigQuery pricing.

Machine learning with BigQuery ML

BigQuery ML allows non-data scientists to build and deploy their machine learning models using SQL language. No need for programming in Python or Java, it removes all the complex and hard to understand mathematical processes of machine learning and uses a simple SQL syntax to create a model.

Read more
BigQuery ML

Google Cloud Platform Training »

Learn how to manage the entire lifecycle of your data on Google Cloud Platform and get hands-on experience.

Learn more

How does Google BigQuery compare to other data warehouse solutions?

Hadoop cluster

  • on-premises solution
  • storing data and powering queries requires managing physical hardware and software
  • based on the concept of nodes (albeit virtual nodes). These are comprised of commodity servers populated with large NL-SAS drives that are used to store and protect the data
  • time-consuming to administer, configure, and optimise both the hardware solution and the Hadoop/Hive software

AWS Redshift

  • cloud solution
  • helps to greatly simplify the management and eliminate the maintenance and the need to physically administer the hardware
  • to scale the deployment, similar nodes of a fixed compute and storage capacity are added simultaneously, sometimes resulting in provisioning more compute or storage capabilities in order to meet the requirements of the other

Google BigQuery

  • completely serverless from the customer perspective
  • There are no nodes to plan, configure, or scale
  • The complexity of sizing, managing, and maintaining the physical infrastructure is handled behind the scenes by Google, so the burden is removed from the end-user. 
Google BigQuery vs other analytical products
Read more

Our featured articles about BigQuery