Reserved Keywords in Formulas

Batch data transforms have reserved keywords that need special handling when manually writing formulas. Use double quotes “ when referencing fields that share a name with reserved keywords. To avoid cross-referencing your field names with this list, the best practice is to use double quotes around all field names.

Enclose fields that share a name with a reserved keyword in double quotes. For example, if your data has a field named Month, you can enter this expression:

case when "Month" = ‘New’ then ‘High’ else ‘Low’

Reserved Keywords

ABS
ADD_MONTHS
AND
ARRAY
ARRAY_JOIN
ARRAY_CONTAINS
BETWEEN
CASE
CEIL
CHAR_LENGTH
COALESCE
CONCAT
CONTAINS
CURRENT_DATE
CURRENT_TIMESTAMP
DATE_ADD
DATEDIFF
DATE_FORMAT
DATE_SUB
DATE_TRUNC
DAY
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DISTINCT
ELSE
END

ENDSWITH
EXP
FALSE
FROM
FLOOR
FORMAT_NUMBER
FROM_UNIXTIME
HOUR
IN
INTERVAL
IS
ISNTR
LAST_DAY
LIKE
LOG
LOWER
LTRIM
MINUTE
MONTH
MONTHS_BETWEEN
NEXT_DAY
NOW
NOT
NULL
NULLIF
OR
POWER

QUARTER
REPLACE
ROUND
RTRIM
SECOND
SIZE
SPLIT
SQRT
STRING
SUBSTR
SUBSTRING
STARTSWITH
THEN
TITLE
TO
TO_DATE
TO_TIMESTAMP
TO_UNIX_TIMESTAMP
TRIM
TRUE
TRUNC
TRUNCNUMBER
UPPER
WHEN
WEEK
WEEKOFYEAR
YEAR

Additional Keywords for Multiple Row Formulas

These keywords are reserved in formulas with the Multiple row formula turned on. Use double quotes " when referencing fields that have any of these names.

CURRENT
DENSE_RANK
FIRST_VALUE
LAG
LAST_VALUE
LEAD
RANK
ROW_NUMBER
SUM

Did this article solve your issue?

Let us know so we can improve!

Reserved Keywords in Formulas