Copy BigQuery table in other region

Question

I created a process in airflow with the main goal of copying BigQuery tables between projects with different regions. But it only works if the projects are in the same region. Is there any way to solve this?

A similar question was asked 2 years ago and I would like to know if there have been any changes in this direction: BigQuery has region restriction or delay between other regions?

Answer 1

You can copy dataset using BigQuery Copy Dataset (in/cross-region). The copy dataset UI is similar to copy table. Just click "copy dataset" button from the source dataset, and specify the destination dataset in the pop-up form. See screenshot below. Check out the public documentation for more use cases.