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

Amazon Redshift supported task types and object types

Amazon Redshift supported task types and object types

The following table lists the tasks and object types that Amazon Redshift Connector supports:
Task Type
Source
Target
Synchronization
Yes
Yes
Mapping
Yes
Yes
When you create a temporary table for an upsert, update, or delete operation in the local staging area, you must create the temporary table in the following format:
RecordName + "_" + time-stamp + ProcessID + PartitionId
By default, you have the permission to create the temporary tables as you have the PUBLIC group membership. To deny the permission, revoke the TEMP permission from the PUBLIC group and allow the TEMP permission to specific or groups of individuals.