Search code examples
google-bigquerydata-transfer

BigQuery Data Transfer - location not supported in command line, but works in GCP UI


I was able to create data transfer in GCP UI from bucket in europe-west3 location to BigQuery dataset which is also located in europe-west3 zone.

When I try to do the same with bq mk --transfer_config ... command, I get an error:

BigQuery error in mk operation: BigQuery Data Transfer Service does not yet support location: europe-west3

Where does this difference come from?


Solution

  • I reproduced the same problem and definitely this is not the expected behavior. If you look in the documentation (and in the image below), you'll see that this feature is not available in this specific region. The only regions available in Europe for Data Transfer are europe-north1, europe-west2 and europe-west6 Also, this region was never mentioned in any release notes.

    enter image description here

    Given that, I opened a ticket for your case in Issue Tracker (Google support channel). You can find the progress in this link