Unable to use table sampling #416
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.
BigQuery don't support sampling with order function in sqlalchemy. By sampling I mean raw SQL looks like this SELECT * FROM dataset.my_table TABLESAMPLE SYSTEM (10 PERCENT).
Describe the solution you'd like
Wondering if it's possible that sampling function can be added.
Describe alternatives you've considered
If RAND() is supported in sqlalchemy, we then can get shuffled sample together with select(with where condition).
Additional context
Add any other context or screenshots about the feature request here.
The text was updated successfully, but these errors were encountered: