Usual JSON formatting gives me a ‘failure’ error. So far, I had to remove comma between items.
i.e)
{ “A”:“11”,“B”:“22” } { “A1”:“11”,“B1”:“22” } { “A2”:“11”,“B2”:“22” } works
but
{ “A”:“11”,“B”:“22” } ,{ “A1”:“11”,“B1”:“22” } ,{ “A2”:“11”,“B2”:“22” } doesn’t work
then having key labels like xxx with for the items also fails.
{“xxx”:[ { “A”:“11”,“B”:“22” } { “A1”:“11”,“B1”:“22” } { “A2”:“11”,“B2”:“22” } ]}
When ETL drops data into JSON format, it displays data like
{“xxx”:[ { “A”:“11”,“B”:“22” } { “A1”:“11”,“B1”:“22” } { “A2”:“11”,“B2”:“22” } ]}
That’s common json format , right ?
Is there an easy way to import data to QuickSight without applying manual cleanup?
My current manifest.json is something like this
{
“fileLocations”: [{
“URIs”: [
“s3://~~xxx_json.csv”
]
}],
“globalUploadSettings”: {
“format”: “JSON”,
“delimiter”: “,”,
“textqualifier”: “"”,
“containsHeader”: “true”
}
}