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

Lookup transformation

Lookup transformation

You can configure full
SQL ELT optimization
to push a Lookup transformation to process in Amazon Redshift. You can push both a connected and an unconnected lookup.
Consider the following rules when you configure a lookup in a mapping:
  • You can configure a lookup to Amazon S3 only when the source used is Amazon S3.
  • You can configure a lookup to Amazon Redshift when the source used is Amazon S3 or Amazon Redshift.
You can nest the unconnected lookup function with other expression functions.For more information on specific rules for lookups, see Rules and guidelines for Lookup transformation.

0 COMMENTS

We’d like to hear from you!