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
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.