Amazon S3 V2 Connector

Back Next

Reading a compressed JSON file

When you

run a mapping to

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

Bzip2

as the compression format. Use the

.BZ2

file name extension when you use the

Bzip2

compression format to read a JSON file.

Select the required compressed JSON file.

Navigate to

Formatting Options

property field.

Select

Import from schema file

option and upload the schema.

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

{"Field1":"<string>","Field2":"<string>","Field3":<integer>}

Use a row that has data for all the columns as the JSON schema.

Select

Compression Format

Bzip2

from the advanced source properties.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.