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 cross-schema optimization for an Amazon Redshift V2 mapping task

Configuring cross-schema optimization for an Amazon Redshift V2
mapping
task

Perform the following steps to configure cross-schema pushdown optimization for an Amazon Redshift V2
mapping
task:
  1. Create Amazon Redshift ODBC source and target connections, each defined with a different schema.
    For example,
    • Create a
      rs_odbc1
      Amazon Redshift ODBC connection and specify
      CQA_SCHEMA1
      schema in the connection properties.
    • Create a
      rs_odbc2
      Amazon Redshift ODBC connection and specify
      CQA_SCHEMA2
      schema in the connection properties.
  2. Create an Amazon Redshift V2 mapping.
    For example, create a
    m_rs_pdo_crossSchema
    Amazon Redshift V2 mapping.
  3. Add a Source transformation. Include an Amazon Redshift V2 source object and connection to read data using the schema specified in the connection.
    For example, add a Source transformation. Include an Amazon Redshift V2 source object and connection
    rs_odbc1
    to read data using
    CQA_SCHEMA1
    .
  4. Add a Target transformation. Include an Amazon Redshift V2 target object and connection to write data using the schema specified in the connection.
    For example, add a Target transformation. Include an Amazon Redshift V2 target object and connection
    rs_odbc2
    to write data using
    CQA_SCHEMA2
    .
  5. Create an Amazon Redshift V2
    mapping
    task, and perform the following tasks:
    1. Select the configured Amazon Redshift V2 mapping.
      For example, select the
      m_rs_pdo_crossSchema
      Amazon Redshift V2 mapping.
    2. In the
      Advanced Options
      on the
      Schedule
      tab, add
      Pushdown Optimization
      and set the value to
      Full
      .
    3. Select
      Enable cross-schema pushdown optimization
      .
      The following image shows the configured
      Enable cross-schema pushdown optimization
      property:
    4. Save the task and click
      Finish
      .
    When you run the
    mapping
    task, the Secure Agent reads data from the Amazon Redshift source object associated with the
    CQA_SCHEMA1
    schema and writes data to the Amazon Redshift V2 target object associated with
    CQA_SCHEMA2
    schema.