Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

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 directory
Yes
Yes
1
Server-side encryption
Yes
Yes
Client-side encryption
Yes
Yes
1
Analyze target table
Yes
Yes
Retain staging files
Yes
Yes
Copy Command
Yes
Yes
Vacuum Tables
Yes
Yes
Recovery and restart processing
No
Yes
1
Preserve record order on write
No
Yes
1
Working with Large Tables
Yes
Yes
Octal Values as DELIMITER and QUOTE
Yes
Yes
Success and Error Files
Yes
Yes
1
Import objects from different schema
No
Yes
*
You can configure elastic mappings only for Amazon Redshift V2 Connector.
1
Applies only to mappings. The remaining properties are applicable for both mappings and
elastic mappings
in Amazon Redshift V2 Connector.