Transferring to and storing data in the EU location

NEW documentation: This article covers setup for OWOX BI. For the latest guides on setting up FREE connectors and Data Marts, visit the new OWOX Data Marts documentation.

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.

To move your Google BigQuery data to a different location, use one of the following methods.

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.

1. Create a new dataset in the EU location as described in Google Cloud Platform documentation.
2. Create a storage bucket, a Google Cloud Storage container to store the table data from the US datasets.
3. Export the table data into the created bucket with the following settings:
4. In the EU dataset, create a table that references an external data source and transfer your data from Google Cloud Storage.

Each table should be exported separately.

That's it. Now your data is stored in the EU.

After you complete the settings, contact us at bi@owox.com. We'll need your project name and names of the tables in the EU location to check if all the processes work correctly.