Provides requirements and guidance for using SQL identifiers with Firebolt.
Firebolt object identifiers are used to refer to database items such as columns, tables, indexes, views, and engines.
Identifiers must contain at least one character, and no more than 255
characters total.
Unquoted identifiers must adhere to the following syntax:
_
).Firebolt evaluates unquoted identifiers such as table and column names entirely in lowercase. The following queries:
are all equivalent to:
You can keep uppercase identifiers by enclosing them in double-quotes. For example, the following identifiers are unique:
Quoted identifiers can contain any UTF-8 characters of the following Unicode general category values:
@
, #
, -
, $
, %
, ?
, and others. Any object identifier that contains special characters, spaces, or are case-sensitive must be enclosed in double quotes ("
) as follows: "my-column"
or "User@Name"
.User names must conform to the following rules:
@ ! # $ % & ' * + - = ? ^ _ ` { | } ~ .