This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

Reserved words

Reserved words have special meanings to the Firebolt SQL engine. We recommend that you do not use these words for naming databases, tables, columns, variables, or other objects that you define. If you must use a reserved word in this way, enclose it in quotation marks.

ALL
ALTER
AND
ARRAY
BETWEEN
BIGINT
BOOL
BOOLEAN
BOTH
CASE
CAST
CHAR
CONCAT
COPY
CREATE
CROSS
CURRENT_DATE
CURRENT_TIMESTAMP
DATABASE
DATE
DATETIME
DECIMAL
DELETE
DESCRIBE
DISTINCT
DOUBLE
DOUBLECOLON
DOW
DOY
DROP
EMPTY_IDENTIFIER
EPOCH
EXCEPT
EXECUTE
EXISTS
EXPLAIN
EXTRACT
FALSE
FETCH
FIRST
FLOAT
FROM
FULL
GENERATE
GROUP
HAVING
IF
ILIKE
IN
INNER
INSERT
INT
INTEGER
INTERSECT
INTERVAL
IS
ISNULL
JOIN
JOIN_TYPE
LATERAL
LEADING
LEFT
LIKE
LIMIT
LIMIT_DISTINCT
LOCALTIMESTAMP
LONG
NATURAL
NEXT
NOT
NULL
NUMERIC
OFFSET
ON
ONLY
OR
ORDER
OUTER
OVER
PARTITION
PRECISION
PREPARE
PRIMARY
QUARTER
RIGHT
ROW
ROWS
SAMPLE
SELECT
SET
SHOW
TEXT
TIME
TIMESTAMP
TOP
TRAILING
TRIM
TRUE
TRUNCATE
UNION
UNKNOWN_CHAR
UNNEST
UNTERMINATED_STRING
UPDATE
USING
VARCHAR
WEEK
WHEN
WHERE
WITH