CODEWITHSUNDEEP
google-bigquery
Rohan
Rohan

Reputation: 611

Bigquery pricing for Temporary storage

Background

I am loading data to BQ.Each time i load data to BQ using schema autodetect option for which BQ creates a table with schema.Then i download the autogenerated schema and delete the created table. I need to this task ,few times on a shedule basis.

I have read in documentation that: for 100 MB for a month it costs some amount and i have read that loading data is free.

Query

Will this storage cost me any amount?

Apart from storage ,will i be charged for this activity.

Need your suggestions on these.!

Upvotes: 0

Views: 1921

Answers (1)

Pentium10
Pentium10

Reputation: 207893

There is no such term as temporary storage. As you say you will pay the storage for the time that you keep it. There is a cost if you do streaming insert, but if you do a load job from a file there is no cost for the bandwidth, but you pay the storage price as normal. Also you don't pay for cached queries.

The following table summarizes BigQuery pricing. BigQuery's quota policy applies for these operations.

+---------------------+-------------------------+-----------------------------------------------------------------+
| Action              | Cost                    | Notes                                                           |
+---------------------+-------------------------+-----------------------------------------------------------------+
| Storage             | $0.02 per GB, per month | See Storage pricing.                                            |
+---------------------+-------------------------+-----------------------------------------------------------------+
| Long Term Storage   | $0.01 per GB, per month | See Long term storage pricing.                                  |
+---------------------+-------------------------+-----------------------------------------------------------------+
| Streaming Inserts   | $0.01 per 200 MB        | See Storage pricing.                                            |
+---------------------+-------------------------+-----------------------------------------------------------------+
| Queries             | $5 per TB               | First 1 TB per month is free, subject to query pricing details. |
+---------------------+-------------------------+-----------------------------------------------------------------+
| Loading data        | Free                    | See Loading data into BigQuery.                                 |
+---------------------+-------------------------+-----------------------------------------------------------------+
| Copying data        | Free                    | See Copying an existing table.                                  |
+---------------------+-------------------------+-----------------------------------------------------------------+
| Exporting data      | Free                    | See Exporting data from BigQuery.                               |
+---------------------+-------------------------+-----------------------------------------------------------------+
| Metadata operations | Free                    | List, get, patch, update and delete calls.                      |
+---------------------+-------------------------+-----------------------------------------------------------------+

All this is explained better on the official page: https://cloud.google.com/bigquery/pricing

You can check out your current usage on this page:
https://console.cloud.google.com/billing/unbilledinvoice

And there is a pricing calculator here:
https://cloud.google.com/products/calculator/

Update

Storage pricing is prorated per MB, per second. For example, if you store:

  • 100 MB for half a month, you pay $0.001 (a tenth of a cent)
  • 500 GB for half a month, you pay $5
  • 1 TB for a full month, you pay $20

Upvotes: 2

Related Questions