Error When Table is Created with Column Names Inside Double Quotes While Using a Transformation Expression

This documentation assumes that you know the command to create/replace the table in the specified schema. A table can have multiple columns with names and different data types. However, if you create a table with column names defined inside double quotes/quotation marks, the column names become case-sensitive. For example:

CREATE OR REPLACE TABLE EMPLOYEES("Name" VARCHAR, "Role" 
VARCHAR, "EmpId" VARCHAR;) )

The following error occurs while using a transformation expression (bulk import operation) in the Adapter Endpoint Configuration Wizard.

SQL compilation error: error line <value> at position <value>\\ninvalid 
identifier 'NAME'\",\n  \"sqlState\"…

Solution: Ensure that you use the command to create/replace a table and define column names without double quotes ("-"). For example:

CREATE OR REPLACE TABLE EMPLOYEES(Name VARCHAR, Role VARCHAR, EmpId VARCHAR).