snowflake.snowpark.functions.divnull

snowflake.snowpark.functions.divnull(dividend: Union[Column, str, int, float], divisor: Union[Column, str, int, float]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.29.0/snowpark-python/src/snowflake/snowpark/functions.py#L2188-L2218)

Performs division like the division operator (/), but returns NULL when the divisor is 0 (rather then reporting error).

Example:

>>> df = session.create_dataframe([1], schema=["a"])
>>> df.select(divnull(df["a"], 1).alias("divided_by_one"), divnull(df["a"], 0).alias("divided_by_zero")).collect()
[Row(DIVIDED_BY_ONE=Decimal('1.000000'), DIVIDED_BY_ZERO=None)]
Copy
Language: English