google cloud bigquery costing

Question

We are using bigquery for storing our data. Google cloud charge us a lot for billing we actual store data approx 2 GB current month but in the billing for current they charge us for 200 TB with they are saying resource.

We are not querying any thing on bigquery and we are not using any public dataset for our use.

Pls help us to figure out this charges for what is it for storing public dataset ?

While I sympathise, the best course of action is to open a ticket with customer support. — NPSF3000, Feb 23 '18 at 04:01

Xiaoxia Lin · Accepted Answer · 2018-03-02T15:06:49.317

1

You have a high BigQuery API traffic, I believe the 197.10 Tebibyte usage for BigQuery Analyisis is from there if you are not querying anything via UI.

To get the exact usage for each BigQuery job, you can use BigQuery API Jobs:list and get in the response fields such as totalBytesProcessed and totalBytesBilled.

Now with this information in hand, you can calculate the charges. The price is $5 per TB beyond your first 1 TB of data processed in a month. In your case: (197.10 - 1) * 5= $ 980.5

edited Mar 02 '18 at 15:06

answered Mar 01 '18 at 15:15

Xiaoxia Lin

736
6
16

how about following statement `We are not querying any thing on bigquery`? :o) I think this was a core of question! – Mikhail Berlyant Mar 01 '18 at 15:38
@MikhailBerlyant, I was able to inspect their project, and they have a lot of BigQuery API requests. I think they are just not querying anything via bigquery UI. – Xiaoxia Lin Mar 02 '18 at 09:27
as expected - :o) - so, I think this what is important to explain to OP – Mikhail Berlyant Mar 02 '18 at 13:23
Thanks for the suggestion, I have edited my answer. Hopefully it is more clear now. – Xiaoxia Lin Mar 02 '18 at 15:09

google cloud bigquery costing

1 Answers1