snowflake.snowpark.functions.row_number¶

snowflake.snowpark.functions.row_number() → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.44.0/src/snowflake/snowpark/functions.py#L8964-L8995)¶

Returns a unique row number for each row within a window partition. The row number starts at 1 and continues up sequentially.

Example:

>>> from snowflake.snowpark.window import Window
>>> df = session.create_dataframe(
...     [
...         [1, 2, 1],
...         [1, 2, 3],
...         [2, 1, 10],
...         [2, 2, 1],
...         [2, 2, 3],
...     ],
...     schema=["x", "y", "z"]
... )
>>> df.select(col("X"), row_number().over(Window.partition_by(col("X")).order_by(col("Y"))).alias("result")).sort("X", "result").show()
------------------
|"X"  |"RESULT"  |
------------------
|1    |1         |
|1    |2         |
|2    |1         |
|2    |2         |
|2    |3         |
------------------

Copy