Identifiers

in the {{ocient}} system, identifiers are lexical tokens that name specific entities in the database for example, a table name is an identifier in most cases, you do not have to quote an identifier however, the identifier must meet these two conditions start with a letter followed by zero or more letters, digits, or underscores must not be a reserved word for the full list of reserved words, see docid\ y mqznfpfl0n7m2a6lctf if the identifier does not meet either of these conditions, then enclose the identifier in double quotes "" to create a delimited identifier sql is case insensitive, and the database normalizes identifiers to lowercase for example, you must add double quotes to the 1start with digit , hy phen , and mixedcase identifiers so that the database can parse them correctly "1start with digit" , "hy phen" , and "mixedcase" 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 data pipeline type related links docid\ xtsavs7f thjc42f2oniz docid\ y mqznfpfl0n7m2a6lctf docid\ uacarixqhe493vlhudb5b docid\ twelobi0rarxjfiot1a70 docid\ dsqzzzggetdfwh5qasvhg docid\ xga0pas8wadtq33 a x7v docid\ hcnnsmzcvpai1kqlhtzud