Is there a way to determine or specify what geo region BigQuery stores data in? -


is there way determine region (like these) bigquery storing data in? more point, there way specify data gets stored when sent bigquery? if matters, i'm using both post method bulk loading data , streaming well.

if answer both of these "no", does bq store data? in usa, elsewhere...or spread on globe?

note: in post should considered guideline , not guarantee. when in doubt, refer bigquery terms-of-service, spell out in more detail guaranteed respect data location.

by default, bigquery stores data in us-central1 , us-central2. if want bigquery data close computation (i.e. gce), should move computation 1 of regions.

bigquery location information on dataset. there 3 possible values, currently: us, eu, , unspecified. if us, data located in (us-central1 , us-central2), eu, data located in eu (europe-west1, although additional replicas may stored elsewhere in eu). if unspecified, equivalent storing in us.

you can see doing datasets.get() operation, can bq command line client via:

bq --format=prettyjson show publicdata:samples | grep location 

note default, location empty, means location unspecified.

location must set when dataset created; (for now) whitelisted set of customers can set dataset location.


Comments

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -