Query performance optimizations #362
Labels
api: bigquery
Issues related to the googleapis/python-bigquery API.
type: feature request
‘Nice-to-have’ improvement, new feature or different behavior or design.
This issue tracks the "fast query path" changes for the Python client(s):
jobs.getQueryResults
to download result sets #363 -- UpdateQueryJob
to usegetQueryResults
inRowIterator
. Project down to avoid fetching schema and other unnecessary job stats inRowIterator
.jobs.getQueryResults
rows #374 -- UpdateQueryJob
andRowIterator
to cache the first page of results, which we fetch as part of the logic to wait for the job to finish. Discard the cache ifmaxResults
orstartIndex
are set.getQueryResults
from DB-API #375 -- Update DB-API to avoid direct call to list_rows()to_dataframe
if all rows are cached #384 -- Updateto_dataframe
and related methods in RowIterator to not call BQ Storage API if cached results are the only page.job_config
s.QueryJob.to_dataframe
andQueryJob.to_arrow
The text was updated successfully, but these errors were encountered: