search

snowflakedb / snowpark-java-scala

Snowflake Snowpark Java & Scala API
Apache License 2.0
18 stars 20 forks source link

SNOW-875095: Add `offset` param to `DataFrame.limit()` #44

Open PatArse opened 1 year ago

PatArse commented 1 year ago

Hi,

I'm currently using Snowpark 1.8.0 in a Java project and I noticed there is a limit(n) method on DataFrames, but no offset(n) method.

I spoke with someone from Snowflake who says there is a method in the Python version of Snowpark and he suggested that I ask here.

Any plan on adding support for that method or a work around in the meantime ?

Thank you !

sfc-gh-jfreeberg commented 1 year ago

Hi @PatArse -- I just checked the Snowpark Python reference API and there's no DataFrame.offset() method, but there is an "offset" param in the DataFrame.limit() method: https://docs.snowflake.com/developer-guide/snowpark/reference/python/latest/api/snowflake.snowpark.DataFrame.limit

How about we update this issue to instead request the "offset" param to be added to the ~DataFrame.offset()~ DataFrame.limit() method?

PatArse commented 1 year ago

I think you mean adding the offset param to the DataFrame.limit(), but yes that would be great !