To be honest, I have not found anything useful on this issue in Google documentation, hence it is not clear how to calculate it correctly
How does storage price work in BigQuery? Each day will be counted a different price and then summarized or should I count some average number for the month?
Example:
For simplicity we don’t take into account active and long term storage, single price for all = 0,02$ per GiB per month
There are two tables in GiB, the data in the tables changes every day
1st table
- day 1 = 10 GiB
- day 2 = 20 GiB
- day 3 = 15 GiB
- …
- day 30 = 50 GiB
2nd table
- day 1 = 15 GiB
- day 2 = 10 GiB
- day 3 = 5 GiB
- …
- day 30 = 10 GiB
- what would be the formula to calculate the data cost per day for each table? e.g. I want to calculate for “day 1” and “day 18”, there are 30 days in a month.
- what would be the formula for calculating the data cost per table per month? I want to calculate the cost per table per month, in a month of 30 days
- do bigquery calculates this cost every day or at the end of the month?
New contributor
Nik is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1