Google BigQuery

Pricing

BigQuery offers flexible on-demand pricing available via self-signup. This provides maximum flexibility for customers with highly variable analytic workloads who desire a pay-as-you-go model. BigQuery supports analysis of petabytes of data, thus we also provide reserved capacity pricing for customers with consistent or larger workloads. For reserved capacity and/or support, we encourage you to contact a sales representative.

Contents

  1. Pricing philosophy
  2. Pricing
  3. On-demand pricing
  4. Reserved capacity pricing
  5. How am I charged for queries?
  6. Terms

Pricing philosophy

Big Data analysis engine without operating a data center

  • Managed service means no additional capital costs
  • Ability to terminate service and remove your data at any time

Transparency in pricing and usage

  • Simplicity: only 2 pricing components (query processing, storage)
  • Flexibility: choice to pay-by-the-month for what you use

Full Visibility and Control

  • Monthly billing: Monitor and throttle what you use
  • Tools to optimize usage/costs: best practices, tooling, samples

Pricing

Prices are effective April 1, 2014.

Resource Pricing
Loading data Free
Exporting data Free
Table reads Free
Storage $0.026 (per GB/month) 3
Streaming Inserts

Free until July 1, 2014

After July 1, 2014, $0.01 (per 100,000 rows) for streaming inserts.

On-demand pricing

On-demand queries use a shared pool of resources across users. Please see the quota policy for usage limits.

Resource Pricing
Interactive Queries $0.005 (per GB processed)1,2,3
Batch Queries $0.005 (per GB processed) 1,3

1Charges rounded up to the nearest MB; minimum 10 MB data processed per each table referenced by a query
2The first 100 GB of data processed per month is at no charge
3Charges 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 for reserved capacity, contact a sales representative.

How am I charged for queries?

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. For instance, if a table has 26 columns, and you run the following query:

SELECT a, b, f FROM table1 WHERE d > 100 ORDER BY e

You would be charged for processing data in columns a, b, f, d, and e only. For more information on column-oriented database structures, see Column-oriented DBMS.

BigQuery accesses all rows of a table when you run a query on the table, and charges according to the total data processed in the columns you select. For this reason, if you expect your queries to be generally focused on data from a particular time frame, it can be economical and sometimes better performing to shard your data into separate tables based on a timestamp.

If you receive a query error, you aren't charged for that query.

Terms

See your license agreement covering BigQuery and the BigQuery Quota Policy page for usage details and full terms.

1Charges rounded up to the nearest MB; minimum 10 MB data processed per each table referenced by a query
2The first 100 GB of data processed per month is at no charge
3Charges are based on the uncompressed data size.

Authentication required

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

Signing you in...

Google Developers needs your permission to do that.