Enable case-sensitive identifiers property
To maintain the case-sensitivity of Greenplum object names, you can manually enter double quotation marks around each name or set the Enable case-sensitive identifiers property to Yes.
The Greenplum connector automatically generates and runs SQL statements. The SQL statements that are generated contain the names of the columns and the name of the table on which to complete the operation. The table name that is used in each SQL statement matches the table that is specified in the Table name property.
By default, the Greenplum database converts all object names to lowercase before it matches the names against the Greenplum object names in the database. If the names of the Greenplum objects are all lowercase, the way that you specify the names in the connector properties does not affect schema matching. However, if the Greenplum object names use all uppercase or mixed case, you must specify the names exactly as they are specified in the Greenplum schema. In addition, you must enclose each name in double quotation marks or set the Enable case-sensitive identifiers property to Yes.