You want to ensure that data lives in a single, consistent region as it is synced from your source database to your destination warehouse using Fivetran. This could be for a couple of primary reasons:
- Security & Compliance (ex: GDPR)
- Minimize Latency
In order to make sure that your data remains in a consistent region for database connectors, you will need to configure all three respective servers for each stage of the data lifecycle:
- Source Database
For #2, Fivetran gives you the option to select the region of Fivetran servers used for processing your data when configuring your destination. We support servers in the following regions:
- Asia-Pacific (APAC)
Note that regions can contain multiple zones within them (ex: us-east-1). Fivetran supports choosing a processing location at the regional level.