How Can I Change the Data Location Region of My Fivetran Account?

Question

How can I store my connectors' data in a preferred location in BigQuery?

Environment

BigQuery destination

Example Use Case

I want to store my data in the us_east_4 (N. Virginia) location. Our AWS infrastructure is in us_east_4, so we need our data to be stored at the same location.

Answer

In the BigQuery destination setup form, you will notice 2 fields: Data Location and Data Processing Location.

1. Set the Data Location as US_EAST_4 from the dropdown.
2. Use the Data processing location drop-down menu to select the region from which you'd like Fivetran to run your syncs.

Once you set the data location as US_EAST_4, all of your connectors’ schemas will get created in this location.

NOTE: You can not change the dataset location once the destination is created.

If you have already created a BigQuery destination with a different Data Location and want to use the same BigQuery project ID, do the following:

1. Create another destination with the same project. In the BigQuery destination setup form, select the Data Location as US_EAST_4.

2. You can do either of the following:

   • Pause the connector for which you want to change the data set location and remove the particular connector dataset from BigQuery.
   • In the new destination, create connectors having a different schema name from the previous destination. The same schema name can't exist in a BigQuery dataset.