Replicating datasets across regions in BigQuery

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.

No alt text provided for this image

Found it useful? Subscribe to my Analytics newsletter at notjustsql.com.