If it's important for your business to store user data you collect into Google BigQuery with OWOX BI within the European Union, you can transfer the existing data from the US (United States) to the EU (European Union) multi-region locations.
In this article, we describe three possible methods of how you can do it.
Important: After you have transferred your data to another location, we need to adjust the pipelines to send data to the new tables. To make this happen, write to us at firstname.lastname@example.org specifying the name of your project and the names of the tables in the EU location.
Method 1. Use the dataset copy feature in Google Data Transfer (now in beta)
The newest method provided by Google. The feature is free while in beta. It lets you copy datasets in the same region or across regions. The feature is a part of BigQuery Data Transfer Service, so make sure you have it enabled.
Read the detailed guide to copying datasets in the BigQuery documentation.
Method 2. Use a Google Cloud Storage bucket
You need to create new datasets located in the EU location a Google Cloud Storage bucket which will be the destination for the old dataset data and the source for the new datasets.
- Create a new dataset in the EU location as described in Google Cloud Platform documentation.
- Create a storage bucket, a Google Cloud Storage container to store the table data from the US datasets.
- Export the table data into the created bucket with the following settings:
- In the EU dataset, create a table that references an external data source and transfer your data from Google Cloud Storage:
That's it. Now your data is stored in the EU.
Do not forget to write to us that you have reconfigured the further sending of data to a new location. Just write to us at email@example.com specifying the name of your project and the names of the tables in the EU location.