Amazon Redshift Connectors > Part III: Data Integration with Amazon Redshift Connector > Amazon Redshift SQL ELT optimization > Cross-schema SQL ELT optimization
  

Cross-schema SQL ELT optimization

You can configure cross-schema SQL ELT optimization for a mapping task that uses a Amazon Redshift ODBC connection to read or write data to Amazon Redshift objects of different schemas in the same database.
To use cross-schema SQL ELT optimization, create Amazon Redshift ODBC connections and specify the schema for the source and target connections. The source and target schemas must be different but must belong to the same database. Configure SQL ELT optimization for the mapping task and enable cross-schema SQL ELT optimization in the advanced session properties. By default, the Enable cross-schema SQL ELT optimization check box is selected.

Configuring cross-schema SQL ELT optimization for an Amazon Redshift mapping task

Perform the following steps to configure cross-schema SQL ELT optimization for an Amazon Redshift mapping task:
    1Create Amazon Redshift ODBC source and target connections, each defined with a different schema.
    For example,
    2Create an Amazon Redshift mapping.
    For example, create a m_rs_pdo_crossSchema Amazon Redshift mapping.
    3Add a Source transformation. Include an Amazon Redshift source object and connection to read data using the schema specified in the connection.
    For example, add a Source transformation. Include an Amazon Redshift source object and connection rs_odbc1 to read data using CQA_SCHEMA1.
    4Add a Target transformation. Include an Amazon Redshift target object and connection to write data using the schema specified in the connection.
    For example, add a Target transformation. Include an Amazon Redshift target object and connection rs_odbc2 to write data using CQA_SCHEMA2.
    5Create an Amazon Redshift mapping task, and perform the following tasks:
    1. aSelect the configured Amazon Redshift mapping.
      2. For example, select the m_rs_pdo_crossSchema Amazon Redshift mapping.
    2. bOn the Runtime Options tab, set SQL ELT Optimization to Full.
    3. cThen, select Enable cross-schema SQL ELT optimization.
    4. dSave 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 target object associated with CQA_SCHEMA2 schema.