Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Amazon Redshift
  3. PowerExchange for Amazon Redshift Configuration
  4. Amazon Redshift Connections
  5. PowerExchange for Amazon Redshift Data Objects
  6. Amazon Redshift Mappings
  7. Pushdown Optimization
  8. Amazon Redshift Lookup
  9. Appendix A: Amazon Redshift Datatype Reference
  10. Appendix B: Troubleshooting

PowerExchange for Amazon Redshift User Guide

PowerExchange for Amazon Redshift User Guide

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 flat files in an Amazon S3 bucket to Amazon Redshift.
You can specify the Copy command options directly in the
Copy Options
field. Enter the options in uppercase and use a semicolon to separate the options. For example,
DELIMITER=\036;ACCEPTINVCHARS=#;QUOTE=\037;COMPUPDATE=ON;AWS_IAM_ROLE=arn:aws:iam::<account ID>:role/<role-name>
Even if you specify the delimiter as a semicolon, you must use a semicolon to separate the options. For example,
DELIMITER=;;ACCEPTINVCHARS=#;QUOTE=\037;COMPUPDATE=ON;AWS_IAM_ROLE=arn:aws:iam::<account ID>:role/<role-name>
You can create a property file to specify the Copy command options. Enter the options in uppercase in separate lines. You must place the property file in any location in the machine on which the Data Integration Service runs. For example:
DELIMITER = \036 ACCEPTINVCHARS = # QUOTE = \037 COMPUPDATE = ON AWS_IAM_ROLE=arn:aws:iam::<account ID>:role/<role-name>
The property file contains the Copy command options. Include the property file path in the
Copy Options
field. For example:
C:\Temp\Redshift\copyoptions.txt
It is recommended to use octal representation of non-printable characters as DELIMITER and QUOTE.

0 COMMENTS

We’d like to hear from you!