Auto populate timestamp in DynamoDB

Question

I come from Relational Database background and we have a way to populate timestamp for row creation and update. I am having difficulty finding similar feature for DynamoDB.

I checked DynamoDB to check if they support autopopulate the date timestamp for every entry in dynamoDB. I see it is possible to create random ID but that is not what I need.

My usecase is to add a timestamp entry automatically when I add any entry to DynamoDB Table. Appreciate any pointers. Thanks

Answer 1

Java Solution using Annotation (Data modelling package)

You can use the DynamoDBAutoGeneratedTimestamp annotation.

@DynamoDBAutoGeneratedTimestamp(strategy=DynamoDBAutoGenerateStrategy.CREATE)
public Date getCreatedDate() { return createdDate; }
public void setCreatedDate(Date createdDate) { this.createdDate = createdDate; }

@DynamoDBAutoGeneratedTimestamp(strategy=DynamoDBAutoGenerateStrategy.ALWAYS)
public Date getLastUpdatedDate() { return lastUpdatedDate; }
public void setLastUpdatedDate(Date lastUpdatedDate) { this.lastUpdatedDate = lastUpdatedDate; }

DynamoDBAutoGeneratedTimestamp

Answer 2

There is no such functionality like DEFAULT CURRENT TIMESTAMP or UPDATE CURRENT_TIMESTAMP. You will have to set the date by yourself.

However if you want to keep track of changes on updates then you can use something like atomic counters.

Thus on every update your will increment the counter value.