Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

BigQuery Snapshot actual size and cost

BigQuery Snapshots are a great way for backing up data due to its cost efficiency, as only changed data is being saved.

But I would like to see how much are we being charged for each snapshot -> how large this delta really is, and consequently, what is the cost of having it. Is this possible? Where can I find this information?

Kind regards

0 1 356
1 REPLY 1

My understanding is that we can run a query over the INFORMATION_SCHEMA.TABLE_STORAGE_USAGE_TIMELINE view ... see here.  This will apparently tell us the charge for storage for THAT table.