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

Cross-Schema pushdown optimization

Cross-Schema pushdown optimization

You can configure cross-schema pushdown 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 pushdown 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 pushdown optimization for the
mapping
task and enable cross-schema pushdown optimization in the advanced session properties. By default, the
Enable cross-schema pushdown optimization
check box is selected.