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 staging directory for Amazon Redshift targets

Amazon Redshift staging directory for Amazon Redshift targets

The agent creates a staging file in the directory that you specify in the target properties. The
synchronization
tasks, mappings, and
mapping
tasks stage data in a staging directory before writing data to Amazon Redshift. You can configure the task to retain or delete staging files.
You cannot configure a directory on Hosted Agent. The Hosted Agent creates a directory to stage data at a temporary location and deletes the staging files from the temporary location when the task completes.
To improve task performance, enable compression for staging files. Specify a staging directory with an appropriate amount of disk space for the volume of data that you want to process. Specify a directory path that is available on each Secure Agent machine in the runtime environment.
The applications creates subdirectories in the staging directory based on the time that the task runs. Subdirectories use the following naming convention:
<staging directory>/infaRedShiftStaging<MMddHHmmssSSS+xyz>