Query Ocient
General SQL Syntax

Identifiers

In the System, identifiers are lexical tokens that name specific entities in the database. If you want to use special characters or reserved words, then enclose them in double quotes "" to create a delimited identifier. For example, a table name is an identifier. If you enclose the table name in double quotes, then it is a delimited identifier.

The system uses identifiers to identify these objects:

  • Database name
  • Schema name
  • Function name
  • Table name
  • Table alias name
  • Column name
  • Column alias name
  • Index name
  • View name
  • Task name
  • Node names
  • Machine learning model name
  • Connectivity pool name
  • Connectivity pool participant name
  • Storage space name
  • Cluster name
  • Service class name
  • Single sign-on (SSO) protocol
  • Tag name
  • JSON key
  • Username
  • Group name
  • Common table expression
  • Subexpression name
  • Data pipeline name (BETA)
  • Data pipeline type (BETA)

Related Links

SQL Reference