Configuring the Redshift connector as a target

You can configure the connector to write data to Redshift data warehouse.

1. On the job design canvas, double-click the Redshift Connector stage.
2. Select the input link to edit.
3. Set the name of the schema in Schema name property.
4. Provide the name of the target table in Table name property.
5. Specify the type of table action required to be performed before Redshift connector stage writes the data. The following table lists out the methods you can configure for Table action:

   Method	Description
   Append	Append mode creates the table if the table doesn’t exist. If the table already exists, no action is performed.
   Replace	Replace mode drops the existing table and creates a new table with the existing job design schema.
   Truncate	Truncate mode truncates the existing table.

6. Specify how Redshift connector stage writes data to a Redshift database table. The following table lists he methods you can use to configure the connector for Write mode.

   Method	Desription
   Insert	Insert mode inserts data to the table specified.
   Merge	Merge mode first updates the table based on the key columns specified and then inserts the data into the table.
   Update	Update mode just updates the table data based on the key columns.

7. Optionally, you can specify a comma separated list of column names in Key column names property, when Write mode is selected as Update or Merge to override the primary key used during Update or Merge.
   Usage - When no value is provided for this property, the primary key columns defined in the table will be used as keys during the update or merge operations. When Key column property is specified, these values will be overridden by the columns provided.
8. Click Ok, and then save the job.