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

Copy command

Copy command

You can use the Copy command to append data in a table. The Copy command uses a secure connection to load data from source to Amazon Redshift.
You can specify the Copy command options directly in the
CopyOptions Property File
field. Enter the options in uppercase and delimit the options by using a The Copy command has the following options and default values:
The property file contains the Copy command options. Include the property file path in the
CopyOptions Property File
field. For example:
C:\Temp\Redshift\copyoptions.txt
It is recommended to use octal representation of non-printable characters as DELIMITER and QUOTE.