# What's the expected JSON format as data source?

**URL:** <https://community.amazonquick.com/t/whats-the-expected-json-format-as-data-source/13222>\
**Category:** Q&A\
**Tags:** formatting, quick-sight\
**Created:** [May 9, 2023, 1:02pm UTC](https://community.amazonquick.com/t/whats-the-expected-json-format-as-data-source/13222 "2023-05-09T13:02:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tbdori](https://avatars.discourse-cdn.com/v4/letter/t/85e7bf/32.png) [@tbdori](https://community.amazonquick.com/u/tbdori)\
**Post date:** [May 9, 2023, 1:02pm UTC](https://community.amazonquick.com/t/whats-the-expected-json-format-as-data-source/13222/1 "2023-05-09T13:02:32Z")

</div>

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 Quick Sight 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”  
}  
}

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [May 9, 2023, 1:36pm UTC](https://community.amazonquick.com/t/whats-the-expected-json-format-as-data-source/13222/2 "2023-05-09T13:36:28Z")

</div>

I would suggest using Athena. Quick Sight does not parse JSON in the best format and is pretty limited. Athena will allow you to create easy datasets with CSVs & JSON.

> **[Interactive SQL - Amazon Athena - AWS](https://aws.amazon.com/athena/)**
>
> Amazon Athena is a serverless, interactive analytics service that provides a simplified and flexible way to analyze petabytes of data where it lives.

In regards to your manifest file it seems as though the format should be a CSV because that’s what the file format is.
