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

snowflake.snowpark.functions.is_null_value

snowflake.snowpark.functions.is_null_value(col: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.16.0/src/snowflake/snowpark/functions.py#L4635-L4647)

Returns true if the specified VARIANT column contains a JSON null value.

Example:

>>> from snowflake.snowpark.functions import to_variant, is_null_value
>>> df = session.create_dataframe([[{"a": "foo"}], [{"a": None}], [None]], schema=["a"])
>>> df.select(is_null_value(to_variant("a")["a"]).as_("a")).collect()
[Row(A=False), Row(A=True), Row(A=None)]
Copy
Language: English