You can use the Connect CDC grammar “quoted identifier” feature to reference column (or table) names that contain blanks or special identifiers. In Connect CDC’s grammar, the double quote character (") is used to delimit one of these special identifiers. In some databases a quoted identifier is referred to as a “delimited identifier.”
For example, for a column name defined as 'My test case column!'; the column name contains all characters except the single quotes. When you have an SQL statement or Connect CDC expression referencing this column, this type of column needs to be specified as a quoted identifier. For example:
"My test case column!"The use of double quotes ensures that the embedded spaces and special characters do not cause a parsing error in the grammar of the database or Connect CDC. Using double quotes enables Connect CDC (and any SQL database) to unambiguously parse this identifier as a column name.
Quoted identifiers can be used for table names, schema names and database names, if this latter type of identifier is supported in the database as it is in MS SQL Server. In addition, a valid column name (one that does not contain special characters that cannot be parsed) can also be specified as a quoted identifier. For example, a column named 'INVOICE_NUMBER'; could also be specified as a quoted identifier such as: "INVOICE_NUMBER".