Condition Functions

This section provides reference information for the condition functions in PlaidCloud Lakehouse.

CASE

Learn how to use the CASE condition function in PlaidCloud Lakehouse. Evaluates conditions and returns a value when the first condition is met.

COALESCE

Learn how to use the COALESCE condition function in PlaidCloud Lakehouse. Returns the first non-NULL expression from a list of expressions.

IF

Learn how to use the IF condition function in PlaidCloud Lakehouse. Returns one of two values depending on whether a condition is TRUE or FALSE.

IFNULL

Learn how to use the IFNULL condition function in PlaidCloud Lakehouse. Returns the first expression if it is not NULL, otherwise returns the second expression.

NULLIF

Learn how to use the NULLIF condition function in PlaidCloud Lakehouse. Returns NULL if two expressions are equal, otherwise returns the first expression.