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

Configuring optimization for an Amazon Redshift V2 mapping task

Configuring optimization for an Amazon Redshift V2
mapping
task

Perform the following steps to configure pushdown optimization for an Amazon Redshift V2
mapping
task:
  1. Create an Amazon S3 V2 connection and an Amazon Redshift V2 connection.
  2. Create a
    mapping
    to read data from an Amazon S3 source and write data to an Amazon Redshift target.
  3. Create a
    mapping
    task.
    1. Select the configured
      mapping
      .
    2. In the
      Advanced Session Properties
      on the
      Schedule
      tab, add
      Pushdown Optimization
      and set the value to
      Full
      .
    3. Save the task and click
      Finish
      .
When you run the mapping task, the transformation logic is pushed to the Amazon Redshift database.