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

snowflake.snowpark.functions.get_path

snowflake.snowpark.functions.get_path(col: ColumnOrName, path: ColumnOrName) 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