-
Notifications
You must be signed in to change notification settings - Fork 127
Closed
Labels
api: bigqueryIssues related to the googleapis/python-bigquery-pandas API.Issues related to the googleapis/python-bigquery-pandas API.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.‘Nice-to-have’ improvement, new feature or different behavior or design.
Description
It can cost a lot to run a SELECT * FROM my_table
query, and yet from an API perspective, this query is completely unnecessary, as one can list the rows from the table directly for free with tabledata.list
. I propose
df = pandas_gbq.read_gbq("my-project.my_dataset.my_table")
which will download a table directly (using bigquery_client.list_rows().to_dataframe()
). Since all queries must contain some kind of whitespace and table IDs cannot contain any whitespace, we can use that to disambiguate query versus table ID.
Metadata
Metadata
Assignees
Labels
api: bigqueryIssues related to the googleapis/python-bigquery-pandas API.Issues related to the googleapis/python-bigquery-pandas API.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.‘Nice-to-have’ improvement, new feature or different behavior or design.