Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

DB-API should have option to use Session API (preview) in connection and/or cursor #971

Open
tswast opened this issue Sep 14, 2021 · 5 comments
Open

DB-API should have option to use Session API (preview) in connection and/or cursor #971

tswast opened this issue Sep 14, 2021 · 5 comments
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.

Comments

@tswast
Copy link
Contributor

tswast commented Sep 14, 2021

We'll get more details later, but https://cloud.google.com/bigquery/docs/sessions-intro recently released. This would map well to user expectations of DB-API objects, but could be considered a breaking change.
@tswast tswast added type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design. semver: major Hint for users that this is an API breaking change. next major: breaking change this is a change that we should wait to bundle into the next major version labels Sep 14, 2021
@tswast tswast added this to To do in google-cloud-bigquery 3.0.0 via automation Sep 14, 2021
@product-auto-label product-auto-label bot added the api: bigquery Issues related to the googleapis/python-bigquery API. label Sep 14, 2021
@tswast tswast self-assigned this Sep 14, 2021
@tswast
Copy link
Contributor Author

tswast commented Sep 14, 2021

Assigning myself for now, since this will require some design work.

@tswast tswast changed the title Breaking Change: DB-API should use Session API in connection and/or cursor DB-API should have option to use Session API (preview) in connection and/or cursor Sep 17, 2021
@tswast tswast removed semver: major Hint for users that this is an API breaking change. next major: breaking change this is a change that we should wait to bundle into the next major version labels Sep 17, 2021
@tswast tswast removed this from To do in google-cloud-bigquery 3.0.0 Sep 17, 2021
@durey
Copy link

durey commented Jan 19, 2022

Hi, just to check: there is currently no way of making use of temp tables in BigQuery (from this python library) until this is implemented, right? Are there any plans in the roadmap? I see it was even removed from the v3 to do list...

@tswast
Copy link
Contributor Author

tswast commented Mar 25, 2022

@durey It's possible to use temp tables by sending a single query request with multiple queries separated by semicolons. But it would be more like other systems if we were to implement this. See also the discussion on #377

@tswast
Copy link
Contributor Author

tswast commented Mar 25, 2022

Note: I removed the "semver: major" as I think we might be able to add this as an option when creating a "connection" object.

@tswast tswast mentioned this issue Mar 25, 2022
Closed
@tswast tswast removed their assignment Apr 14, 2022
@tswast tswast mentioned this issue Apr 26, 2022
Merged
@chalmerlowe
Copy link
Contributor

See the discussion on #377 for context and background.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
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.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@tswast @durey @chalmerlowe