snowflake.snowpark.functions.to_json¶

snowflake.snowpark.functions.to_json(e: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.30.0/snowpark-python/src/snowflake/snowpark/functions.py#L8335-L8349)¶

Converts any VARIANT value to a string containing the JSON representation of the value. If the input is NULL, the result is also NULL.

Example::

CopyExpand

>>> from snowflake.snowpark.types import VariantType, StructField, StructType
>>> from snowflake.snowpark import Row
>>> schema = StructType([StructField("a", VariantType())])
>>> df = session.create_dataframe([Row(a=None),Row(a=12),Row(a=3.141),Row(a={'a':10,'b':20}),Row(a=[1,23,456])], schema=schema)
>>> df.select(to_json(col("a")).as_('ans')).collect()
[Row(ANS=None), Row(ANS='12'), Row(ANS='3.141'), Row(ANS='{"a":10,"b":20}'), Row(ANS='[1,23,456]')]

Show lessSee more

Scroll to top