Hi All -
In my scenario, Loading data from 100 of Json files.
Problem is, fields/columns are missing when JSON file contains new fields.
Full Load:
while writing JSON to delta use the option ("mergeschema", "true") so that we do not miss new columns
Incremental Load:
Problem is here as schema does not match with existing schema.
Could you please assist with schema comparison while doing incremental load.
New JSON files schema should compare with existing JSON files schema.