Skip to content

Automatic parsing of flat schema

Suppose we are to parse the following JSON string into the flat output schema shown below.

Input JSON

[
    {
        "FirstName":"Alice",
        "LastName":"Smith"
    },
    {
        "FirstName":"Bob",
        "LastName":"Johnson"
    }
]

Output schema

Column	Data type
FirstName	`string`
LastName	`string`

The connector automatically parses JSON by binding JSON properties to the corresponding columns of the output schema.

Result

FirstName: `string`	LastName: `string`
Alice	Smith
Bob	Johnson