I would like to copy Company A Bigquery's Dataset to Company B Bigquery.
What is a good way to transfer Bigquery dataset from one account to another?
I looked up and there are 2 options below:
1. BigQuery Data Transfer Service: I don't know if it can help me copy dataset from one organization 's GCP account to another. It only has information for copying dataset to different region.
2. Transfer Data Manually: Basically export from Company A's Bigquery to GCS, share GCS, then import to Company B's BigQuery.
I don't know if BigQuery Data Transfer Service would even be possible?
I read from option 1 that: "Extraction, uploading to a Cloud Storage bucket, and loading data into BigQuery is free." So would option 1 and 2 cost mostly the same if option 1 is possible?
That can be done if network and vpc sc policies allows the direct connection. You can have a service account allowed to do this transfer once cross org policies are set.
You can also explore the Analytics Hub where you can publish public dataset for them to subscriber. All these needs to have the proper policies are inplace to secure your data as well.
Otherwise, you can do the manual step you outline. You can export and download locally (application server). Then, you can upload to the target. It is not going to be a direct communication from ORG A to ORG B.