Conditional expression functions

Snowflake conditional expression functions supported in Snowflake compatibility mode.

Preview

Snowflake conditional expression functions in Snowflake compatibility mode.

Function	Support	Notes
COALESCE	Supported
EQUAL_NULL	Supported	Two NULLs compare equal, as in Snowflake.
GREATEST_IGNORE_NULLS	Supported
GREATEST	With limitations	A NULL argument is skipped and a value returned, where Snowflake answers NULL. Use GREATEST_IGNORE_NULLS when skipping is what you want.
IFF	Supported
IFNULL	Supported
LEAST_IGNORE_NULLS	Supported
LEAST	With limitations	A NULL argument is skipped, as with GREATEST above.
NOT	Supported
NULLIFZERO	Supported
NULLIF	Supported
NVL2	Supported
NVL	Supported
ZEROIFNULL	Supported
DECODE	With limitations	Available for some argument types only.
BOOLAND, BOOLNOT, BOOLOR, BOOLXOR, REGR_VALX, REGR_VALY	Not supported