Hello! We are currently having an issue with inge...
# ingestion
a
Hello! We are currently having an issue with ingesting descriptions from BigQuery Datasets. The problem seems to be that the query used to obtain the Dataset metadata uses `select x from
{project_id}
.INFORMATION_SCHEMA.SCHEMATA` which automatically sets
region-us
for the query (documentation). We have all our data in
region-eu
, but there does not seem to be any way of specifying region. 1. Can you confirm that
region-us
is being set ? 2. Do you know of any workarounds? All the best, Stian
1
g
seems to be bug in connector cc: @gray-shoe-75895
d
@adamant-sunset-13770, please, can you open a GitHub issue about this. It is a valid ask, and it should be a configuration parameter. It seems like default location can be set for the BigQuery python client -> https://github.com/googleapis/google-cloud-python/pull/5678/files
@adamant-sunset-13770, in the meantime, I checked, and you can pass in the default location to the BigQuery source by adding this to your source config:
Copy code
extra_client_options: 
      location: "EU"
a
@dazzling-judge-80093, thank you for responding! I created the GitHub Issue here, and will look into setting
extra_client_options
as a workaround