CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquery
dzejeu
dzejeu

Reputation: 87

Actual size of BigQuery table's snapshot

BQ documentation states that

Storage costs apply for table snapshots, but BigQuery only charges for data in a table snapshot that no longer exists in its base table, or that has changed in its base table

Is there any way (UI/programmatic) to check storage size of given snapshot (storage I am billed for)? When checking table's metadata I see size entry which only tells me the size of the base table at the moment of taking snapshot.

Example:
base_table size: 22GB
base_table_snapshot size: 22GB

then after addition of some data to base_table UI shows

base_table size: 24GB
base_table_snapshot size: 22GB

but 22GB was already snapshotted (and did not change), so I should be billed for 24GB.

Upvotes: 0

Views: 922

Answers (1)

guillaume blaquiere
guillaume blaquiere

Reputation: 75910

You don't have the info of the true cost (for now). In fact it works as a Git commit. It take a snapshot at a point of time. All the new data aren't take into account.

All the changes (update/delete) in the current table that create a diff with the snapshot are stored. You are charged of all that diffs.

More your change your existing snapshotted data, more you pay. If you never change the past, the snapshot are free.

Upvotes: 3

Related Questions