public static interface CopyCommand.Builder extends CopyableBuilder<CopyCommand.Builder,CopyCommand>
Modifier and Type | Method and Description |
---|---|
CopyCommand.Builder |
copyOptions(String copyOptions)
Optional parameters to use with the Amazon Redshift
COPY command. |
CopyCommand.Builder |
dataTableColumns(String dataTableColumns)
A comma-separated list of column names.
|
CopyCommand.Builder |
dataTableName(String dataTableName)
The name of the target table.
|
copy
applyMutation, build
CopyCommand.Builder dataTableName(String dataTableName)
The name of the target table. The table must already exist in the database.
dataTableName
- The name of the target table. The table must already exist in the database.CopyCommand.Builder dataTableColumns(String dataTableColumns)
A comma-separated list of column names.
dataTableColumns
- A comma-separated list of column names.CopyCommand.Builder copyOptions(String copyOptions)
Optional parameters to use with the Amazon Redshift COPY
command. For more information, see the
"Optional Parameters" section of Amazon
Redshift COPY command. Some possible examples that would apply to Kinesis Firehose are as follows:
delimiter '\t' lzop;
- fields are delimited with "\t" (TAB character) and compressed using lzop.
delimiter '|'
- fields are delimited with "|" (this is the default delimiter).
delimiter '|' escape
- the delimiter should be escaped.
fixedwidth 'venueid:3,venuename:25,venuecity:12,venuestate:2,venueseats:6'
- fields are fixed
width in the source, with each width specified after every column in the table.
JSON 's3://mybucket/jsonpaths.txt'
- data is in JSON format, and the path specified is the
format of the data.
For more examples, see Amazon Redshift COPY command examples.
copyOptions
- Optional parameters to use with the Amazon Redshift COPY
command. For more information,
see the "Optional Parameters" section of Amazon Redshift COPY command.
Some possible examples that would apply to Kinesis Firehose are as follows:
delimiter '\t' lzop;
- fields are delimited with "\t" (TAB character) and compressed
using lzop.
delimiter '|'
- fields are delimited with "|" (this is the default delimiter).
delimiter '|' escape
- the delimiter should be escaped.
fixedwidth 'venueid:3,venuename:25,venuecity:12,venuestate:2,venueseats:6'
- fields are
fixed width in the source, with each width specified after every column in the table.
JSON 's3://mybucket/jsonpaths.txt'
- data is in JSON format, and the path specified is
the format of the data.
For more examples, see Amazon Redshift COPY command examples.
Copyright © 2017 Amazon Web Services, Inc. All Rights Reserved.