CODEWITHSUNDEEP
google-bigquery
Daniel M
Daniel M

Reputation: 3

Does querying a public BigQuery dataset counts towards project quota?

I am running a Google Cloud Platform project that utilizes BigQuery in Sandbox mode (no billing enabled). In this project, I query solely public datasets.

The Quota (in IAM & admin) shows 0 MiB although I queried a few 100 GBs already.

This raises the question of whether or not querying public BigQuery datasets counts towards project quota.

Upvotes: 0

Views: 258

Answers (1)

Eric Keen
Eric Keen

Reputation: 423

The first 1TB of data you query will be free. After that you will be billed at $5 per TB.

You can monitor your usage in logs, or I find using billing easier for this, you will get an exact usage figure, Product will be 'BigQuery', SKU will be 'Analysis'. If the data you were querying was not a public dataset you would also be charged for 'Active Storage'.

Relevant quote 1:

You pay only for the queries that you perform on the data (the first 1 TB per month is free, subject to query pricing details).

And 2:

To get started using a BigQuery public dataset, you must create or select a project. The first terabyte of data processed per month is free, so you can start querying public datasets without enabling billing. If you intend to go beyond the free tier, you must also enable billing.

Source: https://cloud.google.com/bigquery/public-data/

Upvotes: 3

Related Questions