Google+

Google Cloud Platform

Features

All behind the scenes

Your queries can execute asynchronously in the background, and can be polled for status. Access a history of your jobs and queries alongside the rest of your Cloud Platform resources in the Google Cloud Console.

Import data with ease

Bulk load your data using Google Cloud Storage or stream it in bursts of up to 1,000 rows per second. You can tackle real-time, high-volume logging or transaction recording and have your data available for analysis quickly and easily.

Affordable big data

When we say “Big Data”, we really mean it. The first 100 GB of data processed each month is free. We will store and query thousands of terabytes for you. Our pricing structure is simple and transparent, and we give you full visibility and control. You only pay for the storage you need and the queries you run.

The right interface

Separate interfaces for administration and developers will make sure that you have access to the tools you need. Control access at both the project and dataset level using the Google APIs Console. BigQuery helps teams of any size work the way they want to work.

Case Studies

Learn how the data-crunching capabilities of BigQuery are being put to use by other companies.

Interactions Marketing's case study image

Interactions Marketing

"We are always looking for ways to maximize return and minimize investment. BigQuery is the perfect combination. It’s an on-demand, scalable resource."

Read Interactions Marketing's story
Boo-box's case study image

Boo-box

"We can now provide our customers information that we couldn’t in the past. This improves their engagement with the service and has even increased their ad spend."

Read Boo-box's story
redBus's case study image

redBus

"We explored several data analytics solutions. Nothing comes remotely close to the sheer power of Google BigQuery. It made large-scale data collection and crunching possible with little effort, which has translated to a significant business advantage."

Read redBus's story

Pricing

BigQuery uses a columnar data structure, which means that for a given query, you are only charged for data processed in each column, not the entire table. The first 100GB of data processed per month is at no charge.

Prices are effective April 1, 2014.

On-Demand Pricing

Resource Pricing
Loading Data Free
Exporting Data Free
Storage $0.026 per GB / month1,4
Interactive Queries $5 per TB processed2,3,4
Batch Queries $5 per TB processed2,3,4
Streaming Inserts Free until July 1, 2014

After July 1, 2014, $0.01 per 100,000 rows for streaming inserts.
   1 Charges rounded up to the nearest MB; minimum 1 MB data per table
   2 Charges rounded up to the nearest MB; minimum 1 MB data processed per each table referenced by a query
   3 The first 100 GB of data processed per month is at no charge
   4 Charges are based on the uncompressed data size.

Reserved Capacity Pricing

For larger, more consistent workloads, reserved capacity can save as much as 70% off On-Demand Pricing. To sign up please contact a sales representative.

Documentation & Resources

Comprehensive documentation and tutorials will teach you how to integrate BigQuery into your application. Learn how to bulk-load data, stream inserts and run queries asynchronously. Access the capabilities of BigQuery from your other Cloud Platform services quickly.

BigQuery Documentation

Resources

  • What is BigQuery?

    Querying massive datasets can be time consuming and expensive without the right hardware and infrastructure. Google BigQuery solves this problem by enabling super-fast, SQL-like queries against append-only tables, using the processing power of Google's infrastructure. Simply move your data into BigQuery and let us handle the hard work.

  • Loading data into BigQuery

    Before you can query your data, you first need to load it into BigQuery. You can bulk load the data by using a job, or stream records individually.

  • Querying data

    Queries are written in BigQuery's SQL dialect. BigQuery supports both synchronous and asynchronous query methods. Both methods are handled by a job, but the "synchronous" method exposes a timeout value that waits until the job has finished before returning.

View all resources

Authentication required

You need to be signed in with Google+ to do that.

Signing you in...

Google Developers needs your permission to do that.