Identifiers

in the 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\ j ox37ldhmgzexb2vqcwv 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\ xwxcjgujvz3h0ldtot gs sql reference docid\ ntdu6jmn5tj143igbgvh machine learning model functions docid\ x1e 9lz6mo mguoh2rah connectivity pools docid\ os6ixwvq3vqyxxebcnfde users, groups, and service classes docid\ tltjovpwkjdggrcxmy2ov