Configure Amazon Redshift in a copy activity

This article outlines how to use the copy activity in data pipelines to copy data from Amazon Redshift.

Supported configuration

For the configuration of each tab under copy activity, go to the following sections respectively.

Refer to the General settings guidance to configure the General settings tab.

Go to Source tab to configure your copy activity source. See the following content for the detailed configuration.

Screenshot showing source tab and the list of properties.

The following three properties are required:

Data store type: Select External.
Connection: Select an Amazon Redshift connection from the connection list. If no connection exists, then create a new Amazon Redshift connection by selecting New.
Use query: Select from Table or Query.

If you select Table:
- Table: Specify the name of the table. Select the table from the drop-down list or enter the name manually by selecting Edit.
If you select Query:
- Query: Specify the custom query to read data. For example: select * from MyTable.

Under Advanced, you can specify the following fields:

Additional columns: Add additional data columns to store source files' relative path or static value. Expression is supported for the latter.

See the following table for the summary and more information of the Amazon Redshift copy activity.

Name	Description	Value	Required	JSON script property
Data store type	Your data store type.	External	Yes	/
Connection	Your connection to the source data store.	< your Amazon Redshift connection >	Yes	connection
Use query	The way to read data. Apply Table to read data from the specified table or apply Query to read data using queries.	• Table • Query	Yes	• typeProperties (under `typeProperties` -> `source`) - schema - table • query
Additional columns	Add additional data columns to store source files' relative path or static value. Expression is supported for the latter.	• Name • Value	No	additionalColumns: • name • value