bigquery database only connected in US location

[dennisyoshikawa]

hi there, hopefully you can help me we install kanaries in compute engine (GCP), but when i connected to bigquery dataset, only datasets located in US were successfully connected to kanaries, because most of our dataset is located in asia-southeast2, I would really appreciate your solution.

[ysj0226]

Hello, can you provide the error information?

The connector does not have location-dependent Settings. If different regions give different results, I think it might be a time-out problem.

You can consider using it https://kanaries.cn/connector

This is a connector deployed on an Asian node.

You can still use the old connector, I raised the timeout limit.

[dennisyoshikawa]

when i open this link (https://kanaries.cn/connector) it show like this, what should i have to do to get the connector, thanks a lot for your help

[ysj0226]

This is the address of a connector, and you should use it just as you used other connector before. As shown below:

Again, you can continue the same way without making any changes, I've extended the timeout.

The error message I would like to know is the error you would get when connecting to bigquery dataset located in Asia. Since the connector doesn't have any locale Settings, this helps me locate specific problems

[ramihan]

https://cloud.google.com/bigquery/docs/information-schema-datasets-schemata#scope_and_syntax

I had the same problem. Referring to this document, it seems that region delimiter input should be added.

[nizamarusada]

@ysj0226 I have dataset in region "asia-southeast1" when I changed the https://kanaries.cn/connector, the connection still not working and the alert still refer to region "us". thank you for your assistant.