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
Add Source Object
Select the source object that you want to add from the displayed list.
Related Objects Actions
window, you can click
to add more objects.
Set your own conditions or specify a query to define the relationship between the tables:
When you configure a join expression, select the fields and define a join condition or a query syntax.
The following image shows an example of an advanced join condition defined between the Amazon Redshift V2 tables: