Configuring pushdown optimization for Amazon Redshift using the ODBC Connector

Configuring pushdown optimization for Amazon Redshift using the ODBC Connector

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.

0 COMMENTS

We’d like to hear from you!