Class: Aws::Firehose::Types::CopyCommand
- Inherits:
-
Struct
- Object
- Struct
- Aws::Firehose::Types::CopyCommand
- Defined in:
- gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb
Overview
Describes a COPY
command for Amazon Redshift.
Constant Summary collapse
- SENSITIVE =
[]
Instance Attribute Summary collapse
-
#copy_options ⇒ String
Optional parameters to use with the Amazon Redshift
COPY
command. -
#data_table_columns ⇒ String
A comma-separated list of column names.
-
#data_table_name ⇒ String
The name of the target table.
Instance Attribute Details
#copy_options ⇒ String
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 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.
744 745 746 747 748 749 750 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 744 class CopyCommand < Struct.new( :data_table_name, :data_table_columns, :copy_options) SENSITIVE = [] include Aws::Structure end |
#data_table_columns ⇒ String
A comma-separated list of column names.
744 745 746 747 748 749 750 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 744 class CopyCommand < Struct.new( :data_table_name, :data_table_columns, :copy_options) SENSITIVE = [] include Aws::Structure end |
#data_table_name ⇒ String
The name of the target table. The table must already exist in the database.
744 745 746 747 748 749 750 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 744 class CopyCommand < Struct.new( :data_table_name, :data_table_columns, :copy_options) SENSITIVE = [] include Aws::Structure end |