AWS SDK Version 3 for .NET
API Reference

AWS services or capabilities described in AWS Documentation may vary by region/location. Click Getting Started with Amazon AWS to see specific differences applicable to the China (Beijing) Region.

Describes a COPY command for Amazon Redshift.

Inheritance Hierarchy

System.Object
  Amazon.KinesisFirehose.Model.CopyCommand

Namespace: Amazon.KinesisFirehose.Model
Assembly: AWSSDK.KinesisFirehose.dll
Version: 3.x.y.z

Syntax

C# 
public class CopyCommand

The CopyCommand type exposes the following members

Constructors

NameDescription
Public Method CopyCommand()

Properties

NameTypeDescription
Public Property CopyOptions System.String

Gets and sets the property 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 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.

Public Property DataTableColumns System.String

Gets and sets the property DataTableColumns.

A comma-separated list of column names.

Public Property DataTableName System.String

Gets and sets the property DataTableName.

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

Version Information

.NET Core App:
Supported in: 3.1

.NET Standard:
Supported in: 2.0

.NET Framework:
Supported in: 4.5, 4.0, 3.5