Google Cloud Platform
Hide

BigQuery

Analyze Big Data in the cloud with BigQuery. Run fast, SQL-like queries against petabytes of data in seconds. Scalable and requiring no setup or administration, BigQuery gives you real-time insights about your data.

Start your free trial

BigQuery is Google's fully managed, NoOps, data analytics service. With BigQuery you have no infrastructure to manage, don't need a database administrator, use familiar SQL and can take advantage of a pay-as-you-go model. This myriad of features allows you to focus on what matters most: unlocking meaningful insights to better serve your customers. Organizations of all sizes, from Fortune 500 to startups, have adopted BigQuery as their Big Data analytics platform of choice.

Features

Flexible data ingestionFlexible data ingestion

Load your data from Google Cloud Storage or Google Cloud Datastore, or stream it into BigQuery at 100,000 rows per second to enable real-time analysis of your data.

Fast and performantFast and performant

BigQuery's columnar architecture is designed to handle nested and repeated fields in a highly performant manner, enabling super-fast queries to help you save time and money.

Affordable big dataAffordable big data

Loading and exporting data, and metadata operations, are free of charge. Pay only for what you store and what you query, and the first 1 TB of data processed each month is free. For more information see the BigQuery pricing page.

Ease of collaborationEase of collaboration

BigQuery enables you to access, save and share complex datasets. You can also specify what permissions they have on the dataset.

ProtectedProtected

BigQuery is built with a replicated storage strategy. All data is encrypted both in-flight and at rest. You can protect your data with strong role-based ACLs that you configure and control.

Strong partner ecosystemStrong partner ecosystem

Partners have integrated BigQuery with some of the industry-leading tools for loading, transforming and visualizing data.

Pricing calculator

The Pricing Calculator provides you with a simple tool that can help you get a sense of what an application running on Google Cloud Platform could cost.

Get a custom quote

Pricing

When charging in local currency, Google will convert the prices listed into applicable local currency pursuant to the conversion rates published by leading financial institutions.

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 1 TB of data processed per month is at no charge.

On-Demand Pricing

Resource Pricing
Loading Data Free
Exporting Data Free
Storage $0.020 per GB / month1,4
Interactive Queries $5 per TB processed2,3,4
Batch Queries $5 per TB processed2,3,4
Streaming Inserts $0.01 per 100,000 rows until August 12, 2015. After August 12, 2015, $0.01 per 200 MB, with individual rows calculated using a 1 KB minimum size.
   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 1 TB of data processed per month is at no charge
   4 Charges are based on the uncompressed data size.