Amazon S3 V2 Connector

Back Next

Reading a compressed flat file

When you

run a mapping to

read data from a compressed flat file, you must upload a schema file and select

Gzip

as the compression format. Use the

.GZ

file name extension when you use the

Gzip

compression format to read data from a flat file.

Select the required compressed flat file.

Navigate to

Formatting Options

property field.

Select the

Import from schema file

option and upload the schema.

The following figure shows a sample schema file for a flat file:

{"Columns":[{"Name":"f_varchar","Type":"string","Precision":"256","Scale":"0"},{"Name":"f_char","Type":"string","Precision":"256","Scale":"0"},{"Name":"f_smallint","Type":"string","Precision":"256","Scale":"0"},{"Name":"f_integer","Type":"string","Precision":"256","Scale":"0"},{"Name":"f_bigint","Type":"string","Precision":"256","Scale":"0"},{"Name":"f_decimal_default","Type":"string","Precision":"256","Scale":"0"},{"Name":"f_real","Type":"string","Precision":"256","Scale":"0"},{"Name":"f_double_precision","Type":"string","Precision":"256","Scale":"0"},{"Name":"f_boolean","Type":"string","Precision":"256","Scale":"0"},{"Name":"f_date","Type":"string","Precision":"256","Scale":"0"},{"Name":"f_timestamp","Type":"string","Precision":"256","Scale":"0"}]}

Select

Compression Format

GZIP

from the advanced source properties.

Data compression in Amazon S3 V2 sources and targets

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal