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

What happens to BigQuery datasets during natural disaster

Hi Folks,

I'm creating all my tables under a single region and not in multi-region (let's assume us-east4). So in this case if any natural disaster happens in North Virginia (hope it wont), what happens to my datasets and tables as I have stored in single region. 

Just curious to know what happens on these kind of scenario. Any suggestions on this or any Google documentation is much appreciated?

 

Thanks,

Vigneswar

Solved Solved
0 1 113
1 ACCEPTED SOLUTION

If a region were to have an outage ... and remember ... that should be extraordinarily rare .... then the data would not be available.  If the region were permanently lost ... your data would be lost.   Remember, Google replicates data to multiple ZONES within a region.  The loss of a ZONE should be transparent.  The loss of a region should be A MAJOR-MAJOR-MAJOR disaster.

If you need the insurance to recovery from a whole region loss ... Google has "Cross Region dataset replication" (see here).

View solution in original post

1 REPLY 1

If a region were to have an outage ... and remember ... that should be extraordinarily rare .... then the data would not be available.  If the region were permanently lost ... your data would be lost.   Remember, Google replicates data to multiple ZONES within a region.  The loss of a ZONE should be transparent.  The loss of a region should be A MAJOR-MAJOR-MAJOR disaster.

If you need the insurance to recovery from a whole region loss ... Google has "Cross Region dataset replication" (see here).