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/v1.16.0/src/snowflake/snowpark/functions.py#L5162-L5177)¶

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