snowflake.snowpark.functions.seq2¶
- snowflake.snowpark.functions.seq2(sign: int = 0) Column [source]¶
Returns a sequence of monotonically increasing integers, with wrap-around which happens after largest representable integer of integer width 2 byte.
- Parameters:
sign – When 0, the sequence continues at 0 after wrap-around. When 1, the sequence continues at smallest representable 2 byte integer. Defaults to 0.
See also
Session.generator()
, which can be used to generate in tandem with seq2 togenerate sequences.
- Example::
>>> df = session.generator(seq2(0), rowcount=3) >>> df.collect() [Row(SEQ2(0)=0), Row(SEQ2(0)=1), Row(SEQ2(0)=2)]