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 reserved words docid\ k4 hgg15i9h5ywwuuznar 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 sql syntax conventions docid 32zfmno8mwgrfuy2lsjz4 reserved words docid\ k4 hgg15i9h5ywwuuznar database, tables, views, and indexes docid\ ejutg6wjnk5eg55kizq8d sql reference docid\ ulddmgdefqwa9p 2dqlz machine learning model functions docid\ jsgwuw5og56fzrve5h10g cluster and node management docid\ bnlgs0qq1wre7ndja8q0x users, groups, and service classes docid\ iwkirup8638xpra30vnl3