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

Source functionality

Source functionality

When you import an object from Amazon Redshift to read data, you can configure the advance source properties to determine the read operation behavior. For example, you can read data in an encrypted format or you can configure partitioning for optimal performance.
The following table lists the source functionality you can use when you read data from an Amazon Redshift source for Amazon Redshift and Amazon Redshift V2 connectors:
Feature
Amazon Redshift Connector
Amazon Redshift V2 Connector
Staging directory¹
Yes
Yes²
Server-side encryption
Yes
Yes
Server-side encryption with KMS
Yes
Yes²
Client-side encryption
Yes
Yes²
Unload command
Yes
Yes
Partitioning
Yes
Yes²
Working with large tables
Yes
Yes
Octal Values as DELIMITER and QUOTE
Yes
Yes
Success and error files
Yes
Yes
Import objects from different schema
No
Yes
¹ Does not apply to
elastic mappings
. However, you must specify a staging directory on Amazon Redshift in
elastic configurations
. For more information, see
Administrator
.
² Does not apply to
elastic mappings
.