Amazon Redshift Connectors

Back Next

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
¹Doesn't apply to mappings in advanced mode.