Source
IFF
Returns one of two values depending on whether a Boolean expression evaluates to true or false. This function is similar to a single - level if - then - else expression. It is similar to CASE, but only allows a single condition. You can use it…
IS [ NOT ] DISTINCT FROM
Compares whether two expressions are equal (or not equal). The function is NULL - safe, meaning it treats NULLs as known values for comparing equality. Note that this is different from the EQUAL comparison operator (=), which treats NULLs as…
Ternary logic
IFF returns the following results for ternary logic. Given a BOOLEAN column C: If C is: IFF(C, e1, e2) evaluates to: TRUE e1 FALSE e2 NULL e2 [ NOT ] IN behavior [ NOT ] IN returns the following results for ternary logic.
EQUAL_NULL
Compares whether two expressions are equal. The function is NULL - safe, meaning it treats NULLs as known values for comparing equality. Note that this is different from the EQUAL comparison operator (=), which treats NULLs as unknown…
CONCAT , ||
Concatenates one or more strings, or concatenates one or more binary values. The || operator provides alternative syntax for CONCAT and requires at least two arguments.
CASE
Works like a cascading “if - then - else” statement. In the more general form, a series of conditions are evaluated in sequence. When a condition evaluates to TRUE, the evaluation stops and the associated result (after THEN) is returned.
SnowConvert AI - ANSI SQL - Built-in functions
This article provides an alphabetical list of built - in functions shared by the different dialects.
Account Usage
In the SNOWFLAKE database, the ACCOUNT_USAGE and READER_ACCOUNT_USAGE schemas enable querying object metadata, as well as historical usage data, for your account and all reader accounts (if any) associated with the account.
REDUCE
Reduces an array to a single value based on the logic in a lambda expression. The REDUCE function takes an array, an initial accumulator value, and a lambda function. It applies the lambda function to each element of the array, updating…
SnowConvert AI - BigQuery - Built-in functions
Translation reference for all the supported built - in functions by SnowConvert AI for BigQuery. Note For more information about built - in functions and their Snowflake equivalents, also see Common built - in functions. Aggregate…