Uploading multiple S3 files using the same manifest file

Question & Answer
,
1

I’m trying to upload multiple S3 files using a manifest file to Quicksight. But it fails. Has anyone tried uploading multiple S3 files to quicksight using one manifest file? Attaching the manifest file for reference - Both file1 & file2 are same format files

{
“fileLocations”: [
{
“URIs”: [
“https://s3-us-east-1.amazonaws.com/bucketname/BI_file1.csv”,
“https://s3-us-east-1.amazonaws.com/bucketname/BI_file2.csv”,
]
}
],
“globalUploadSettings”: {
“format”: “CSV”
}
}

2

Hi @Malinika - Is the files have same layout? Please confirm. Also there is an extra (,) at the end of the second URI. Can you please remove that and retry.

Regards - Sanjeeb

3

Hello @Malinika - Typically loading multiple S3 files via manifest file works smoothly. You can do it both by specifying the files as well as by adopting the URI prefixes. Please go through the following link which will provide more details :

As @Sanjeeb2022 mentioned, please pay close attention to the syntactical format so that the JSON format doesn’t get invalidated. Hope this helps!