Skip to content
This repository was archived by the owner on Mar 13, 2026. It is now read-only.
This repository was archived by the owner on Mar 13, 2026. It is now read-only.

specify geographical location of table in pandas read_gbq #177

Closed
pandas-dev/pandas
#21628
Closed
specify geographical location of table in pandas read_gbq#177
pandas-dev/pandas
#21628
Assignees
tswast
Labels
accepting pull requests
@rmporsch

Description

@rmporsch
rmporsch
opened on May 7, 2018

I am having trouble setting the geographical location in pandas.read_gbq.

In google.cloud.bigquery I can set the location to asia-northeast1 the following:

from google.cloud import bigquery
bigquery_client = bigquery.Client(project_name)    
query_job = bigquery_client.query(query, location='asia-northeast1')

However, I fail to do this in read_gbq. The following seems not to work:

from pandas_gbq import gbq    
dat = gbq.read_gbq(query, project_id=project_name, jobReference={'location':'asia-northeast1'}, dialect='standard')

Metadata

Metadata

Assignees

Labels

accepting pull requests

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions