Link Search Menu Expand Document

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

Identifier requirements

Firebolt identifiers can refer to the following items:

  • Columns
  • Tables
  • Indexes
  • Databases
  • Views
  • Engines

Syntax

Identifiers must adhere to the following syntax:

  1. Contain at least one character, and no more than 255.
  2. The first character must be a letter (a-z) or underscore (_).
  3. After the first character, subsequent characters can be letters, underscores, digits (0-9).

Unquoted identifiers

Firebolt evaluates unquoted identifiers such as table and column names entirely in lowercase. The following queries:

SELECT my_column FROM my_table
SELECT MY_COLUMN FROM MY_TABLE
SELECT mY_cOlUmn FROM mY_tAbLe

are all equivalent to:

SELECT my_column FROM my_table

Unquoted identifiers in some early Firebolt accounts may be case sensitive.

You can keep uppercase identifiers by enclosing them in double-quotes. For example, the following identifiers are unique:

"COLUMN_NAME"
"column_name"
"CoLuMn_NaMe"