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

Supported features for Amazon Redshift V2 mappings

Supported features for Amazon Redshift V2 mappings

You must configure an Amazon S3 V2 connection with basic or IAM authentication when you enable pushdown optimization in a mapping task.
When you configure pushdown optimization, the mappings support the following advance properties for an Amazon S3 V2 source:
  • Client-side encryption
  • Data compression
    • GZIP only
  • File formatting
    • Delimiter
    • Qualifier
    • Code Page
    • Header Line Number
    • First Data Row
    • Source Type
    • Folder Path
  • File source type
  • File name
  • Format type
    • Avro
    • Parquet
    • ORC
    • JSON
    • Delimited
When you configure pushdown optimization, the mappings support the following advance properties for an Amazon Redshift V2 target:
  • Analyze target table
  • Assume Role
  • COPY command
    • Region
    • Truncatecolumn
    • AWS_IAM_Role, only for Parquet and ORC files
  • Pre-SQL
  • Post-SQL
  • Require null value for Char and Varchar
  • Schema name
  • Target table name
  • Truncate target table before data upload
  • Vacuum table
  • Treat Source Rows As (only INSERT supported)
If you configure source and target advanced properties that are not supported, the mappings run in the Informatica runtime environment.