dataset schema not showing correctly for .json file

arkiboys 9,686 Reputation points

I am trying to load a .json file which has alot of different arrays...
but when I try to create a dataset, in the schema, I do not see all the quantities array items
it only shows me
For example the file is like this:

"dv": "54344",
"book": "hhgg",
"movements": [
"name": "someName",
"state": "completed",
"quantities": [
"planned": "45445",
"uom": "xxx",
"moisture": "55656.99"
"actual": "5656.99",
"uom": "yyy",
"moisture": "3434"
"planned": "23424",
"uom": "ooo",
"moisture": "22323"
"actual": "678678678",
"uom": "dfd",
"moisture": "876867"
"gross": "22323",
"uom": "ghgh"
"net": "2323.99",
"uom": "dff"

however, this is the schema it shows me for quantities.
Any suggestions? thank you


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,110 questions
{count} votes

Accepted answer
  1. Nasreen Akter 10,791 Reputation points

    Hi @arkiboys ,

    Thank you for the ask. I think the best way to load a dataset-schema is by creating a json-schema file with all the possible attributes in it and then load it. For the above example the json-schema file would be something like


    0 comments No comments

0 additional answers

Sort by: Most helpful