In addition to the existing regions, you can also read data from or write data to the

AWS GovCloud

region.

You can specify the part size of an object to download the object from Amazon S3 in multiple parts.

You can encrypt data while fetching the file from Amazon Redshift using the AWS-managed encryption keys or AWS KMS-managed customer master key for server-side encryption.

You can provide the number of files to calculate the number of the staging files for each batch. If you do not provide the number of files, PowerExchange for Amazon Redshift calculates the number of the staging files.

You can use the TRUNCATECOLUMNS option in the copy command to truncate the data of the VARCHAR and CHAR data types column before writing data to the target.

PowerExchange for Amazon Redshift supports version 11 and 12 of SuSe Linux Enterprise Server operating system.