Amazon S3 Connector

Back Next

Amazon S3 Object Format

Amazon S3 objects are delimited files. All fields in a delimited file are of string data type with a data format that you cannot change and with a defined precision of 256. Data in Amazon S3 delimited files is written in String 256 format.

An Amazon S3 delimited file uses the following data format by default:

The delimiter is a comma.

The qualifier is a double-quote.

The escape character is a backslash.

Use

Formatting Options

to override the default data format values.

When you write data to an Amazon S3 file, the application might display an exception when you select incorrect

Formatting Options

. You must select valid

Formatting Options

and proceed with the task.

Ensure that the Amazon S3 file that you read is in a valid format. If the format is not valid, a null pointer exception occurs and an appropriate error message does not appear.

Backslash is the default escape character in the formatting options. Specify a different escape character when you read data from an Amazon file and escape is a part of data.

The

Formatting Options

dialog box does not display backslash as the default escape character. However, backslash is the default escape character. Specify a different escape character when you read from an Amazon S3 file and escape is a part of data.

When you write data to an Amazon S3 file, if there is a single or double quote in the source data, an extra quote is added to the target.

cannot specify space, semi colon, and comma as delimiters in the

Other

option under

Formatting Options

Amazon S3 Objects

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base