snowflake.snowpark.functions.get_path

snowflake.snowpark.functions.get_path(col: Union[Column, str], path: Union[Column, str]) Column[source]

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

Examples:

>>> 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')]
Copy