oso icon indicating copy to clipboard operation
oso copied to clipboard

`pyoso` "preview" mode

Open Jabolol opened this issue 8 months ago • 1 comments

What is it?

TABLESAMPLE MODE (N)

We should allow users to "preview" their pyoso queries. This would be a separate method like client.preview_df(sql). This would either

  • Parse client side the SQL and insert TABLESAMPLE SYSTEM/BERNOULLI (N) for each subquery.
  • Create a new API route which is the dedicated preview route, which would do this tablesample server side
  • Have a "playground" trino cluster which would be the consumer one for this preview methdod

We should allow the user to configure the percent and the mode used when initializing the pyoso client as well.

Jabolol avatar May 10 '25 13:05 Jabolol