Connection Property | Description |
|---|---|
Runtime Environment | The name of the runtime environment where you want to run the tasks. |
Username | User name of the Amazon Redshift account. |
Password | Password for the Amazon Redshift account. |
Schema | Amazon Redshift schema name. Default is public. |
AWS Access Key ID | Optional. Amazon S3 bucket access key ID. To run tasks on Secure Agent installed on an EC2 system, you might leave the Access Key ID blank. To run tasks on Secure Agent that is not installed on an EC2 system, you must provide the Access Key ID. |
AWS Secret Access Key | Optional. Amazon S3 bucket secret access key ID. To run tasks on Secure Agent installed on an EC2 system, you might leave the Secret Access Key blank. To run tasks on Secure Agent that is not installed on an EC2 system, you must provide the Secret Access Key. |
Master Symmetric Key | Optional. Amazon S3 encryption key. Provide a 256-bit AES encryption key in the Base64 format. |
Cluster Node Type | Node type of the Amazon Redshift cluster. You can select the following options:
For more information about nodes in the cluster, see the Amazon Redshift documentation. |
Number of Nodes in the Cluster | Number of nodes in the Amazon Redshift cluster. For more information about nodes in the cluster, see the Amazon Redshift documentation. |
JDBC URL | Amazon Redshift connection URL. |
Number of bytes needed to support multibytes for varchar | Applicable to Create Target. Reads the Varchar precision of the source table and creates the target table with 1x/2x/3x/4x times of the source precision to successfully write multibyte characters in the target table. Note: You cannot create a target table if the Varchar precision exceeds 65535 that is maximum allowed. |