to Amazon Redshift, you must define an integer value for the length argument.
You cannot enable full pushdown optimization for a mapping task when the task contains a mapping with a single transformation connected to multiple transformations downstream and vice-versa.
When you read data from an Amazon S3 flat file with Shift-JIS encoding, write to an Amazon Redshift target, and enable full pushdown optimization, the mapping fails.
When you configure a mapping that reads an Amazon S3 Avro source with column names in uppercase letters and uses an Amazon Redshift V2 connection to write data to an Amazon Redshift target, the COPY command writes blank rows to the target.
You cannot enable full pushdown optimization for an Avro source with Date and Decimal data types.