Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Pushdown optimization types

Pushdown optimization types

When you apply pushdown optimization, the task pushes transformation logic to the source or target database based on the optimization type you specify in the task properties. Data Integration translates the transformation logic into SQL queries or Amazon Redshift commands to the Amazon Redshift database. The database runs the SQL queries or Amazon Redshift commands to process the transformations.
You can configure the following types of pushdown optimization in a mapping:
None
The task does not push down the transformation logic to the Amazon Redshift database.
Full
The task pushes as much of the transformation logic as possible to process in the target database.
Source
The task pushes down as much as the transformation logic as possible to process in the source database. When you select source pushdown optimization, the task pushes the transformation logic for all the configured transformations downstream in the mapping until it reaches the Target transformation. It leaves out the target transformation logic and pushes down the rest of the mapping logic to the source database.