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?