Unable to use table sampling

[XiaoyuLiu198]

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.

[meredithslota]

This is a feature request for BigQuery itself — I believe that table sampling is in "preview" now: https://cloud.google.com/bigquery/docs/table-sampling.