Search code examples
locationdatasetgoogle-bigquery

Move Tables from US dataset to EU dataset

I have created some projects on Google Cloud Platform (and Bigquery) that were located in US. Now I want to create datasets only in EU. Is there any way to copy those tables from US dataset to EU dataset without downloading data locally??

Solution

  • I got the following recommendation from a member of the subteam that owns the import pipeline:

    1. extract to GCS
    2. copy to GCS bucket in other region
    3. import into BQ

    I'm afraid we don't have anything more streamlined than that at this time