Manifest file

Question & Answer
,
1

Hi,

I have 2 questions related to new data source in S3 folder - which is the inventory report of another S3 bucket.
The inventory report produces csv files on a daily basis containing the full content of the S3 bucket.
So the folder has many csv files - one per each day.

my questions would be:

  1. what should be the manifest file?
  2. Is there a way to make sure that each day the data set in quicksight reflects the latest file from folder?
  • This is the manifest file I tried and got a very generic error message with no details:

{
“fileLocations”: [
{
“URIPrefixes”: [
“s3://il-prod-volunteers-consents-inventory/il-prod-volunteers-consents/il-prod-volunteers-consents-inventory/data/”,
]
}
],
“globalUploadSettings”: {
“format”: “CSV”,
“delimiter”: “,”,
“textqualifier”: “”,
“containsHeader”: “false”
}
}

image
image1314Ă—810 43.3 KB

2

Hi @Annab,

Thank you for posting.

  1. Documentation and guidiance how you can create a manifest file for objects in your Amazon S3 bucket can be found here here. If you encounter any errors, kindly review the documentation here.

  2. Your second question is not possible based on your current setup. Please review the post from my colleague here that can help address this.

Regards,
Demola

1 Like
3

the aws documentation does not really explain how to create a manifest file. it just says that we need to put it inside a folder. how can i connect quicksight to s3??? where is the manifest file that i need to upload???. i have no coding skills, and your instructions are … very very bad… please help

4

Hi
It’s not that much difficult :slight_smile:

  • Create the Manifest File: Save the JSON content in a file with a .json extension, e.g., manifest.json.
  • Upload to S3: Upload the manifest file to an S3 bucket.
  • Reference in QuickSight:
  • Go to the QuickSight console.
  • Choose Manage data from the navigation pane.
  • Choose New data set.
  • Choose S3.
  • Enter the S3 URI for your manifest file, e.g., s3://bucket-name/path/to/your/manifest.json.