1 Answer
- Newest
- Most votes
- Most comments
1
Hi there
The manifest file manifest.json
appears to be located at s3://bucketname/manifest.json
, but you are specifying the location as s3://bucketname/manifest
(without the .json
extension).
To resolve the issue, you need to ensure that the manifest file exists in the correct S3 location and specify the correct location in the COPY
command, and ensure it has the .manifest extension. Here's how you can modify the COPY
command:
COPY table
FROM 's3://bucketname/manifest.manifest'
IAM_ROLE 'arn:xxxxx'
manifest;
Also, your manifest entry is pointing to a prefix, it needs to have an entry to each file to load:
{
"entries": [
{"url":"s3://bucketname/2024/03/28/file1", "mandatory":true},
{"url":"s3://bucketname/2024/03/28/file2", "mandatory":true}
]
}
Relevant content
- asked 3 years ago
- asked 3 years ago
- asked a month ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
Thank you for your reply! I tried to add the .json but I got the error - Manifest file is not in correct json format. My manifest file is in json format. Any idea how to modify the manifest file?
Hi There
You manifest entries need to point to a file to load. You are pointing to a prefix
s3://bucketname/2024/03/28/
. You should have an entry for each file that you want to copy in the manifest:I updated my original answer to include this info
Thank you! It worked! QQ does manifest file have to point to a specific file, folders won't work?