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

snowflake.snowpark.functions.get¶

snowflake.snowpark.functions.get(col1: Union[Column, str, int], col2: Union[Column, str, int]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.15.0/src/snowflake/snowpark/functions.py#L6468-L6494)¶

Extracts a value from an object or array; returns NULL if either of the arguments is NULL.

Example:

>>> from snowflake.snowpark.functions import lit
>>> df = session.createDataFrame([({"a": 1.0, "b": 2.0}, [1, 2, 3],), ({}, [],)], ["map", "list"])
>>> df.select(get(df.list, 1).as_("idx1")).sort(col("idx1")).show()
----------
|"IDX1"  |
----------
|NULL    |
|2       |
----------


>>> df.select(get(df.map, lit("a")).as_("get_a")).sort(col("get_a")).show()
-----------
|"GET_A"  |
-----------
|NULL     |
|1        |
-----------