Practical SQL

Replicating datasets across regions in BigQuery

Constantin LunguUpdated 1 min read

Photo by Gianluca Cinnante on Unsplash

So this has been up for almost a year, but I've just found out that you can replicate datasets across regions in BigQuery. Obligatory remark that this is still in preview.

This should help quite a bit if you're working with data distributed across multiple BQ regions.

A couple of years ago, when facing the same task, I had to resort to setting up recurring BigQuery Transfer Service jobs to move data across regions.

BigQuery console Dataset replicas (Preview) screens: the Create replica panel for dataset learning in EU with Multi-region US selected as replica location, and the Replicas list afterwards showing a US Secondary replica from June 11, 2024 next to the EU Primary.