Adding and linking components
Procedure
- Create a new Job and apply all context variables listed above to the new Job.
- Add the following components by typing their names in the design workspace or dropping them from the Palette: a tRowGenerator component, a tRedshiftOutputBulk component, a tRedshiftBulkExec component, a tRedshiftInput component, a tLogRow component, a tRedshiftUnload component, a tS3List component, and a tS3Get component.
- Link tRowGenerator to tRedshiftOutputBulk using a Row > Main connection.
- Do the same to link tRedshiftInput to tLogRow.
- Link tS3List to tS3Get using a Row > Iterate connection.
- Link tRowGenerator to tRedshiftBulkExec using a Trigger > On Subjob Ok connection.
- Do the same to link tRedshiftBulkExec to tRedshiftInput, link tRedshiftInput to tRedshiftUnload, link tRedshiftUnload to tS3List.