I am trying to load ServiceNow data to Redshift. Looks like there are no read snaps available. Got the data to S3 using curl in the json format. Looks like json parser is not parsing the data correctly. Child records are at level 3. I put in a mapper to get the data and associate it to target. After saving and validating, I cannot see the data in Table format. Shows only in Json format.
What am I doing wrong?