The pre-SQL commands to run a query before you read data from Amazon Redshift. You can also use the UNLOAD or COPY command. The command you specify here is processed as a plain text.

The post-SQL commands to run a query after you write data to Amazon Redshift. You can also use the UNLOAD or COPY command. The command you specify here is processed as a plain text.

Number of columns used when sorting rows queried from the source. The PowerCenter Integration Service adds an

ORDER BY

clause to the default query when it reads source rows. The

ORDER BY

clause includes the number of ports specified, starting from the top of the transformation. When you specify the number of sorted ports, the database sort order must match the session sort order.

Selects unique values. The PowerCenter Integration Service includes a SELECT DISTINCT statement if you choose this option. Amazon Redshift ignores trailing spaces. Therefore, the PowerCenter Integration Service might extract fewer rows than expected.

You can override the default source table name.

Amazon S3 bucket name for the Amazon Redshift source data.

Compresses staged files before writing the files to Amazon Redshift.

Amazon Redshift staging directory.

Path to the property file.

Indicates that the PowerCenter Integration Service encrypts data before writing the data to Amazon S3 by using a private encryption key.

Select the source encryption type. You can select from the following encryption types:

SSE-S3
SSE-KMS

Downloads large Amazon S3 objects in multiple parts.

Specifies the part size of an object.

SQL filter command to divide the source database into multiple segments.

Overrides the default query. Enclose column names in double quotes. The SQL query is case sensitive. Specify an SQL statement supported by the Amazon Redshift database.