Iskz opened a new issue #11203:
URL: https://github.com/apache/airflow/issues/11203
We are having issue when trying to use BigQueryHook to retrieve a dataset
which is NOT IN US
```
from airflow.contrib.hooks.bigquery_hook import BigQueryHook
bq_hook = BigQueryHook(bigquery_conn_id='bigquery_default',
location='asia-southeast1', use_legacy_sql=True)
query = """
SELECT * FROM `non-us-dataset.table_id`;
"""
bq_hook.get_records(sql=query)
```
example error:
```
{
'reason': 'notFound',
'message': 'Not found: Dataset dataset-xxx:`dataset_id was not found in
location US'
}.The job was:
{
'kind': 'bigquery#job',
'etag': '123412341234==',
'id': 'dataset-xxx:US.123412341234',
'selfLink':
'https://bigquery.googleapis.com/bigquery/v2/projects/dataset-xxx/jobs/123412341234?location=US',
'user_email': 'service-account',
'configuration':
{
'query':
{
'query': "SELECT * FROM `non-us-dataset.table_id`",
'priority': 'INTERACTIVE',
'useLegacySql': True
},
'jobType': 'QUERY'
},
'jobReference':
{
'projectId': 'dataset-xxx',
'jobId': '12341234',
'location': 'US'
},
'statistics':
{
'creationTime': '1601460946946',
'startTime': '1601460946960',
'endTime': '16014609...'
}
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
