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. Contact OWOX BI support
Write to us at email@example.com and specify the name of the OWOX BI project which data you want to transfer. We’ll do it, so you won’t have to.
Your US-located tables will be copied into new datasets with the _EU tag at the end. The names of the tables inside the datasets will remain unchanged. The newly collected data will be gathered into new tables.
In OWOX BI, EU will become a default location at the project scope. All pipelines created under this project will store data in the EU location.
Method 3. 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.