This repository was archived by the owner on Mar 6, 2026. It is now read-only.
Repository navigation
This repository was archived by the owner on Mar 6, 2026. It is now read-only.
BigQuery: Converting query results to dataframe fails to convert date columns #136
Description
Environment details
google-api-python-client==1.9.3
google-cloud-bigquery==1.25.0
pyarrow==0.17.1
Steps to reproduce
- Issuing a select statement that returns a date column and converting the results to dataframe fails to convert the date column and leaves it as string
Code example
select = "select DATE(date) as dt from [project:dataset.table]"
client = bigquery.Client()
job_config = bigquery.QueryJobConfig(use_legacy_sql=True)
select_job = client.query(select, job_config=job_config)
select_job.result()
df = select_job.to_dataframe()
df.dtypes
# dt object
Activity
HemangChothani commentedon Jun 15, 2020
@darwinyip Could you try to set the dtypes argument to to_dataframe. We don't have any logic to convert from the API response types to pandas dtypes unless the dtypes argument is specified.
Example:
The duplicate issue of #11
darwinyip commentedon Jun 15, 2020
Manually setting the dtype works but it's not a very friendly user experience.
HemangChothani commentedon Jun 16, 2020
@darwinyip Could you please comment on issue #11 as this is the duplicate issue and discussion is going on that thread so you can get better and faster reply, I have already linked and mentioned your comment there so closing this issue.