Solved: Export BigQuery table to Google Cloud Storage in a... - Page 2

mmcgrath1028 · 01-19-2024 10:32 AM

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

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:

Export Table Data to Cloud Storage. You can export the table data to a target bucket in the same location as your dataset.
Grant the required GCS and BigQuery permissions to the account that will load the data by using the IAM console.
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!

View solution in original post

Export BigQuery table to Google Cloud Storage in a separate account