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 using Google BigQuer and Google Cloud Storage tools.
How to transfer your data between the US and EU locations
To transfer your existing Google BigQuery data from the US (United States) to the EU (European Union) location, write to us at firstname.lastname@example.org 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.
If you want to transfer data on your own
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.
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 us at email@example.com specifying the name of your project and the names of the tables in the EU location.