google cloud bigquery costing
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 ?
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