SAFE_DIVIDE (Lakehouse v1)

A PlaidCloud function, available on every lakehouse engine. Divides the first number by the second. When the denominator is zero, or either side is NULL, the result is the third value; pass None to get NULL. All three arguments are required on Lakehouse v1. Both sides are cast to DECIMAL(38, 10) first, so integer columns divide without truncation.

Analyze Syntax

func.safe_divide(<numerator>, <denominator>, <divide_by_zero_value>)

Analyze Examples

func.safe_divide(table.revenue, table.units, 0)

| revenue | units | safe_divide |
|---------|-------|-------------|
| 100     | 8     | 12.5        |
| 100     | 0     | 0           |
| 100     | NULL  | 0           |

func.safe_divide(table.revenue, table.units, None)

| revenue | units | safe_divide |
|---------|-------|-------------|
| 100     | 8     | 12.5        |
| 100     | 0     | NULL        |

SQL Equivalent

There is no SQL function of this name. The expression compiles to:

COALESCE(CAST(<numerator> AS DECIMAL(38, 10)) / NULLIF(CAST(<denominator> AS DECIMAL(38, 10)), 0), <divide_by_zero_value>)