PowerCenter Modernization

Back Next

Amazon Redshift advanced properties

The following tables lists the Amazon Redshift properties that you can configure for a

Connection Map configuration

The following table describes the Amazon Redshift connection properties:

Connection property	Description
Schema	The Amazon Redshift schema name to be used when creating the object. Th schema name is similar to the schema name specified in the SCHEMAMAP.properties file. Default is schema_changeit .

The following table describes the Amazon Redshift source advanced properties:

Property name	Description
Schema Name	Overrides the default schema name.
S3 Bucket Name	Amazon S3 bucket name for staging the data. You can also specify the bucket name with the folder path. If you provide an Amazon S3 bucket name that is in a different region than the Amazon Redshift cluster, you must configure the REGION attribute in the Unload command options.

The following table describes the Amazon Redshift target advanced properties:

Property Name	Description
Schema Name	Overrides the default schema name.
S3 Bucket Name	Amazon S3 bucket name for writing the files to Amazon Redshift target. You can also specify the bucket name with the folder path. If you provide an Amazon S3 bucket name that is in a different region than the Amazon Redshift cluster, you must configure the REGION attribute in the Copy command options.

The following table describes the Amazon Redshift lookup transformation advanced properties:

Property Name	Description
Schema Name	Overrides the default schema name.
S3 Bucket Name	Amazon S3 bucket name for staging the data. You can also specify the bucket name with the folder path. If you provide an Amazon S3 bucket name that is in a different region than the Amazon Redshift cluster, you must configure the REGION attribute in the Copy command options.