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 a custom query or an SQL override for the Amazon Redshift source object

Configuring a custom query or an SQL override for the Amazon Redshift source object

You can push down a custom query or an SQL override to Amazon Redshift.
Before you run a task that contains a custom query as the source object or you configure an SQL override, you must set the
Create Temporary View
session property in the mapping task properties.
If you do not set the
Create Temporary View
property, the mapping runs without pushdown optimization.
Perform the following task to set the property:
  1. In the mapping task, navigate to the
    Advanced Session Properties
    on the
    Schedule
    tab.
  2. From the
    Session Property Name
    list, select
    Create Temporary View
    and set the
    Session Property Value
    to
    Yes
    .
  3. Click
    Finish
    .

Rules and guidelines for a custom query configuration

Consider the following rules when you specify a custom query:
  • If you do not set the flag, the mapping runs without pushdown optimization.
  • You must include all the unique column fields in the SQL query.
  • When you use a custom query or an SQL override in a Source transformation, you must have the permissions to access and perform operations in the Amazon Redshift source and target tables.
  • When you configure an SQL override, make sure that you include all the connected fields in the SQL query.