Amazon Redshift Connectors > Part I: Introduction to Amazon Redshift connectors > Connector comparison > Target functionality
  

Target functionality

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 directory1
Yes
Yes
Server-side encryption
Yes
Yes
Client-side encryption1
Yes
Yes
Analyze target table
Yes
Yes
Retain staging files
Yes
Yes
Copy Command
Yes
Yes
Vacuum Tables
Yes
Yes
Recovery and restart processing1
No
Yes
Preserve record order on write1
No
Yes
Working with Large Tables
Yes
Yes
Octal Values as DELIMITER and QUOTE
Yes
Yes
Success and Error Files1
Yes
Yes
Import objects from different schema
No
Yes
1Doesn't apply to mappings in advanced mode.