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 ODBC mapping task

Configuring optimization for an Amazon Redshift ODBC mapping task

Perform the following steps to configure pushdown optimization in an Amazon Redshift ODBC
mapping
task:
  1. Create a
    mapping
    to read from or write to Amazon Redshift:
    1. Use the Amazon Redshift ODBC connection in the Source transformation.
    2. Use the Amazon Redshift ODBC connection in the Target transformation.
  2. Create a
    mapping
    task.
    1. Select the configured
      mapping
      .
    2. In the
      Pushdown Optimization
      section on the
      Schedule
      tab, set the pushdown optimization value to
      Full
      or
      To Source
      .
    3. Save the task and click
      Finish
      .
When you run the mapping task, the transformation logic is pushed to the Amazon Redshift database. To verify that the pushdown optimization has taken place, you can check the session log for the job. In
Monitor
, view the log for jobs.