snowflake.snowpark.functions.parse_xml¶

snowflake.snowpark.functions.parse_xml(e: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.6.1/src/snowflake/snowpark/functions.py#L4467-L4491)¶

Parse the value of the specified column as a JSON string and returns the resulting XML document.

Example:

CopyExpand

>>> df = session.sql(
...     "select (column1) as v from values ('<t1>foo<t2>bar</t2><t3></t3></t1>'), "
...     "('<t1></t1>')"
... )
>>> df.select(parse_xml("v").alias("result")).show()
------------------
|"RESULT"        |
------------------
|<t1>            |
|  foo           |
|  <t2>bar</t2>  |
|  <t3></t3>     |
|</t1>           |
|<t1></t1>       |
------------------

Show lessSee more

Scroll to top