Yes, you could do this using Google Cloud Platform Pricing Calculator.
To estimate storage costs in the Google Cloud Platform Pricing Calculator, enter the number of bytes that are stored as MB, GB, TB, or PB. BigQuery provides 10 GB of storage free per month.
To estimate storage costs using the pricing calculator:
-
Open the Google Cloud Platform Pricing Calculator,
-
Click BigQuery.
-
Click the On-Demand tab.
-
For Table Name, type the name of the table. For example, airports.
-
For Storage Pricing, enter 100 in the Storage field. Leave the measure set to GB.
-
Click Add To Estimate.
-
The estimate appears to the right. Notice that you can save or email the estimate.