snowflake.snowpark.functions.strip_null_value¶

snowflake.snowpark.functions.strip_null_value(col: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.6.1/src/snowflake/snowpark/functions.py#L4494-L4509)¶

Converts a JSON “null” value in the specified column to a SQL NULL value. All other VARIANT values in the column are returned unchanged.

Example::

CopyExpand

>>> df = session.create_dataframe(
...     ["null", "1"],
...     schema=["S"],
... ).select(strip_null_value(parse_json(col("S"))).as_("B")).where(
...     sql_expr("B is null")
... )
>>> df.collect()
[Row(B=None)]

Show lessSee more

Scroll to top