You are viewing documentation for version 2 of the AWS SDK for Ruby. Version 3 documentation can be found here.

Class: Aws::Firehose::Types::CopyCommand

Inherits:
Struct
  • Object
show all
Defined in:
(unknown)

Overview

Note:

When passing CopyCommand as input to an Aws::Client method, you can use a vanilla Hash:

{
  data_table_name: "DataTableName", # required
  data_table_columns: "DataTableColumns",
  copy_options: "CopyOptions",
}

Describes a COPY command for Amazon Redshift.

Returned by:

Instance Attribute Summary collapse

Instance Attribute Details

#copy_optionsString

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.

Returns:

  • (String)

    Optional parameters to use with the Amazon Redshift COPY command.

#data_table_columnsString

A comma-separated list of column names.

Returns:

  • (String)

    A comma-separated list of column names.

#data_table_nameString

The name of the target table. The table must already exist in the database.

Returns:

  • (String)

    The name of the target table.