snowflake.snowpark.functions.array_position¶
- snowflake.snowpark.functions.array_position(variant: Union[Column, str], array: Union[Column, str]) Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.16.0/src/snowflake/snowpark/functions.py#L5413-L5435)¶
Returns the index of the first occurrence of an element in an ARRAY.
- Parameters:
variant – Column containing the VARIANT value that you want to find. The function searches for the first occurrence of this value in the array.
array – Column containing the ARRAY to be searched.
- Example::
>>> from snowflake.snowpark import Row >>> df = session.create_dataframe([Row([2, 1]), Row([1, 3])], schema=["a"]) >>> df.select(array_position(lit(1), "a").alias("result")).show() ------------ |"RESULT" | ------------ |1 | |0 | ------------