snowflake.snowpark.functions.get_path¶

snowflake.snowpark.functions.get_path(col: Union[Column, str], path: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.25.0/snowpark-python/src/snowflake/snowpark/functions.py#L6759-L6771)¶

Extracts a value from semi-structured data using a path name.

Examples:

CopyExpand

>>> df = session.create_dataframe([{"a": {"aa": {"dd": 4}, "bb": 2, "cc": 3}}])
>>> df.select(get_path(df["a"], lit("aa.dd")).alias("get_path")).collect()
[Row(GET_PATH='4')]

Show lessSee more

Scroll to top