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
Post a Comment