When you import an object from Amazon Redshift to write data, you can configure the advance target properties to determine the write operation behavior. For example, you can write data in an encrypted format or you can retain Amazon S3 staging files after the write operation is complete.

The following table lists the target functionality you can use when you write data to an Amazon Redshift target:

Target functionality	Amazon Redshift Connector	Amazon Redshift V2 Connector
Staging directory 1	Yes	Yes
Server-side encryption	Yes	Yes
Client-side encryption 1	Yes	Yes
Analyze target table	Yes	Yes
Retain staging files	Yes	Yes
Copy Command	Yes	Yes
Vacuum Tables	Yes	Yes
Recovery and restart processing 1	No	Yes
Preserve record order on write 1	No	Yes
Working with Large Tables	Yes	Yes
Octal Values as DELIMITER and QUOTE	Yes	Yes
Success and Error Files 1	Yes	Yes
Import objects from different schema	No	Yes
1 Doesn't apply to mappings in advanced mode.