Search code examples
amazon-dynamodb

import from S3 fails due to question mark

I have a dynamoDB table having "author" as partition key and "title" as sort key.

One of the records has a question mark ? in it's title. If I export the table to S3 and then import it back, it fails.

Are there any other special characters like question mark that will make it difficult to import from S3?

Update:

The table mentioned above is "poemGroup". I have another table called "poems". (Partition key: author (String) and Sort key: title (String). The title is same as title column in poemGroup table (foreign key in SQL dialect). My android app developed in dart, does not display the contents if there is a question mark in the title column. It is possible that the bug is in my source code. https://github.com/ayush290104/MarathiPoet

I just need to confirm that there is no issue from dynamoDB side.

Solution

  • Make sure you specify the correct path for import, ending at data/:

    s3://mybucket/myprefix/AWSDynamoDB/01696928512465-633b755c/data/

    Make sure you select:

    Import compression type = GZIP

    Here is my test:

    My item:

    {
 "PK": "Hello?",
 "SK": "World ?"
}

    My Export

    enter image description here

    My Import

    enter image description here

    My item in the new table

    {
 "PK": "Hello?",
 "SK": "World ?"
}