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

Adding multiple source objects

Adding multiple source objects

When you create a Source transformation, you can select Amazon Redshift V2 multiple object as the source type and then configure a join to combine the tables. You can define a relationship condition or a query to join the tables.
  1. In the Source transformation, click the
    Source Type
    as
    Multiple Objects
    .
  2. From the
    Actions
    menu, click
    Add Source Object
    .
    The image shows how to add a source object.
  3. Select the source object that you want to add from the displayed list.
    The image shows the list of objects from which you can select a source object.
  4. Click
    OK
    .
  5. From the
    Related Objects Actions
    menu, select
    Advanced Relationship
    : The image shows the Advanced Relationship option.
  6. In the
    Advanced Relationship
    window, you can click
    Add Object
    to add more objects.
    Click Add Object to add more objects.
  7. Click
    OK
    .
  8. Set your own conditions or specify a query to define the relationship between the tables:
    The image shows how you can define a relationship between objects.
    When you configure a join expression, select the fields and define a join condition or a query syntax.
  9. Click
    OK
    .
    The following image shows an example of an advanced join condition defined between the Amazon Redshift V2 tables:
    The image shows how an advanced join condition is displayed in the UI.