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

snowflake.snowpark.functions.iff

snowflake.snowpark.functions.iff(condition: Column | str, expr1: Column | None | bool | int | float | str | bytearray | Decimal | date | datetime | time | bytes | list | tuple | dict, expr2: Column | None | bool | int | float | str | bytearray | Decimal | date | datetime | time | bytes | list | tuple | dict) → Column[source]

Returns one of two specified expressions, depending on a condition. This is equivalent to an if-then-else expression.

Parameters:

  • condition – A Column expression or SQL text representing the specified condition.

  • expr1 – A Column expression or a literal value, which will be returned if condition is true.

  • expr2 – A Column expression or a literal value, which will be returned if condition is false.

Examples:

>>> df = session.create_dataframe([True, False, None], schema=["a"])
>>> df.select(iff(df["a"], lit("true"), lit("false")).alias("iff")).collect()
[Row(IFF='true'), Row(IFF='false'), Row(IFF='false')]