Amazon Redshift Connectors

Back Next

Optimizing full pushdown for multiple targets

You can add multiple Amazon Redshift V2 targets in a mapping.

When you configure a mapping to write to multiple Amazon Redshift V2 targets, you can further optimize the write operation when you configure full pushdown optimization.

To optimize, you can choose to configure an insert, update, upsert, delete, or data driven operation for multiple targets individually.

You can select the same or different Amazon Redshift V2 target table in multiple Target transformations and perform different operations for each of the Target transformations to run independent of each other.

Rules and guidelines

Consider the following rules and guidelines when you optimize full pushdown for multiple targets:

When you run a mapping and use the same target table in all the targets, the row count is different from the row count of the mapping that runs without pushdown optimization. Applicable when you use an Amazon S3 source and perform an upsert operation on multiple Redshift V2 targets.

When you run a mapping and use the same target table in all the targets, the Secure Agent writes a different set of data to the target than the data of the mapping that runs without pushdown optimization. Applicable when you use an Amazon S3 source, perform an insert operation on multiple Redshift V2 targets, and enable the

Truncate Target Table Before Data Load

advanced target property.

Pushdown optimization using an Amazon Redshift V2 connection

Download Guide

Watch

Comments