Amazon Redshift Connectors

Back Next

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.

In the Source transformation, click the

Source Type

Multiple Objects

From the

Actions

menu, click

Add Source Object

The image shows how to add a source object.

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.

Click

From the

Related Objects Actions

menu, select

Advanced Relationship

In the

Advanced Relationship

window, you can click

Add Object

to add more objects.

Click

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. To join two tables, you can specify a simple condition. For example,

employee.department=dept.id

. To join more than two tables, you must specify the complete query. For example,

<schema_name>.<table_name1> LEFT OUTER JOIN <schema_name>.<table_name2> ON <schema_name>.<table_name1>.<column_name1>=<schema_name>.<table_name2>.<column_name2>

Click

The following image shows an example of an advanced join condition defined between the Amazon Redshift V2 tables: