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.

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

Support preview of table in SQLAlchemy #411

Open
riordan opened this issue Feb 5, 2022 · 0 comments
Open

Support preview of table in SQLAlchemy #411

riordan opened this issue Feb 5, 2022 · 0 comments
Labels
api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design.

Comments

@riordan
Copy link

riordan commented Feb 5, 2022

Bigquery's a big believer in SELECT * as a bad pattern. This totally makes sense. However, folks use SELECT * all the time as a way of getting the schema (don't ask me why).

While fortunately the BQ API affords the tabledata.list method, which can be used to inexpensively preview results, there doesn't appear to be a way to invoke this from within sqlalchemy.

This is particularly pronounced in tools that use sqlalchemy which have the SELECT * pattern baked in as a way to preview tables (I'm looking at you, apache/superset#17299). If there were a way to invoke this via sqlalchemy, this could allow tools like Superset to more effectively use BQ resources (rather than SELECT * from table every time someone starts to work with it in its sql editor).

@product-auto-label product-auto-label bot added the api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. label Feb 5, 2022
@yoshi-automation yoshi-automation added the triage me I really want to be triaged. label Feb 5, 2022
@meredithslota meredithslota added type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design. and removed triage me I really want to be triaged. labels Feb 9, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design.
Projects
None yet
Development

No branches or pull requests

3 participants