How do I ensure correct schema for this JSON dataset?

Options
sandeep
sandeep Partner, Registered Posts: 4 Partner

Hi there,

Am trying to load data with the below format in Dataiku.

JSON data.PNG

Dataiku automatically detects the following schema:

Schema.PNG

I am getting an error when I run a prepare recipe to rename one of the columns (see below). I suspect it's because the schema is not being read correctly.

Error.PNG

You can access the data from here, would appreciate any form of help in addressing this. Thanks!

Answers

Setup Info
    Tags
      Help me…