You are viewing documentation about an older version (1.16.0). View latest version

snowflake.snowpark.functions.dense_rank

snowflake.snowpark.functions.dense_rank() → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.16.0/src/snowflake/snowpark/functions.py#L6717-L6731)

Returns the rank of a value within a group of values, without gaps in the ranks. The rank value starts at 1 and continues up sequentially. If two values are the same, they will have the same rank.

Example:

>>> from snowflake.snowpark.window import Window
>>> window = Window.order_by("key")
>>> df = session.create_dataframe([(1, "1"), (2, "2"), (1, "3"), (2, "4")], schema=["key", "value"])
>>> df.select(dense_rank().over(window).as_("dense_rank")).collect()
[Row(DENSE_RANK=1), Row(DENSE_RANK=1), Row(DENSE_RANK=2), Row(DENSE_RANK=2)]
Copy
Language: English