You can configure pushdown optimization for a mapping that reads from the following sources and writes to an Amazon Redshift target:
Amazon Redshift V2 source
Amazon S3 V2 source
When you configure a mapping, some parameters are not supported for a mapping enabled for pushdown optimization. You can refer to the list of parameters that each source supports.