Export BigQuery table to Google Cloud Storage in a separate account

[mmcgrath1028]

Hi, 

I am wondering if it is possible to export a BigQuery table under account A to a Google Cloud Storage bucket within another account (account B). From all of the research I've already done it seems like it would be possible given the correct permissions are granted in both accounts but I haven't found a truly definitive answer. I'm planning to use the BigQuery API to automate this process. 

[Marramirez · Accepted solution]

Hello @mmcgrath1028,

Welcome to Google Cloud Community!

You can export your BigQuery table to a Google Cloud Storage bucket then import the data to a BigQuery dataset in your other account.

You can do the following steps:

1. Export Table Data to Cloud Storage. You can export the table data to a target bucket in the same location as your dataset.
2. Grant the required GCS and BigQuery permissions to the account that will load the data by using the IAM console. 
3. Load your data into the destination BigQuery account.

If the above option doesn't work, you can contact Google Cloud Support to further look into your case. Let me know if it helped, thanks!

[mmcgrath1028]

Hi @Marramirez,

Thank you for your response. So I actually don't need to upload the data back into another BigQuery account after I transfer it into Google Cloud Storage. I am using Google Cloud Storage as an archive and once the data is transferred hopefully it won't have to be moved again.

Can you confirm that I can export data from a BigQuery dataset in one account and put it in a Google Cloud Storage bucket in another account? It seems like this is possible given that in your response you mentioned that you can import data from one Google Cloud Storage account to a BigQuery dataset in another account so I assume the reverse would also be achievable. Please let me know if this is not the case. Sorry for the confusion. Thanks.  

[avindia]

I would like to copy BigQuery Views from one Project or Account to another Project and then automate the copy so changes in Source BQ views  can only be copied to Target BQ Views on regular basis. 

Both Projects are in Same GCP region and Zone

Need help to understand type of data transfer mechanism used by BQ ( Copy,Clone,Snapsjot)

2. Authentications mechanism used between source and target 

3. Cost of data transfer if any