CODEWITHSUNDEEP
google-bigquerygoogle-cloud-storage
sobe86
sobe86

Reputation: 43

Is it possible to extract job from big query to GCS across project ids?

Hey guys trying to export a bigquery table to cloud storage a la this example . Not working for me at the moment, am worried that the reason is that the cloud storage project is different to the bigquery table, is this actually doable? I can't see how using that template above.

Upvotes: 1

Views: 278

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 172944

Confirming:
You CAN have your table in ProjectA to be exported/extracted to GCS bucket in ProjectB. You just need make sure you have proper permissions on both sides. At least:

READ for respective dataset in Project A and
and
WRITE for respective bucket in Project B

Please note: Data in respective dataset of Project A and bucket in Project B - MUST be in the same location - US or EU , etc.
Simply to say: sourse and destination must be in the same location

Upvotes: 1

Related Questions