Dynamodb csv import task failed, but table successfully created with correct amount of data imported to it

This looks like you have a 0 byte object in S3, which you believe to be your folder/directory. S3 does not natively support folders but if you use S3 console to create a folder then it creates a 0 byte S3 object.

When you create a folder in Amazon S3, S3 creates a 0-byte object with a key that's set to the folder name that you provided. For example, if you create a folder named photos in your bucket, the Amazon S3 console creates a 0-byte object with the key photos/. The console creates this object to support the idea of folders.

The Amazon S3 console treats all objects that have a forward slash (/) character as the last (trailing) character in the key name as a folder (for example, examplekeyname/). You can't upload an object that has a key name with a trailing / character by using the Amazon S3 console. However, you can upload objects that are named with a trailing / with the Amazon S3 API by using the AWS CLI, AWS SDKs, or REST API.

An object that is named with a trailing / appears as a folder in the Amazon S3 console. The Amazon S3 console does not display the content and metadata for such an object. When you use the console to copy an object named with a trailing /, a new folder is created in the destination location, but the object's data and metadata are not copied.

By design, the import from S3 feature will scan for all S3 objects under a given prefix and attempt to read them. Since <folder name>/ is an S3 object we just treat it as data.

To overcome this issue, try not to create folders using the AWS Web Console, and rather upload your data directly from the CLI or SDK:

aws s3 cp <file> s3://bucket/prefix/to/file.csv