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

2
votes

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?

1
google-bigquerydata-transfer
Can you confirm your --location is set to EU in command line cloud.google.com/bigquery/docs/reference/bq-cli-reference ? - Prabhakar Reddy
gcloud config list shows zone = europe-west3-a. - Juri Krainjukov
I also tried to add --location=EU, but the error stays the same BigQuery Data Transfer Service does not yet support location: europe-west3. As I understand It complains about bucket or dataset zone. - Juri Krainjukov
If the answer helped you, consider accepting :) - rmesteves

1 Answers

1
votes

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