How to get Latest Record from DynamoDB using boto3 Python

Your issue is that you use timestamp as a partition key, which will not allow you to retrieve the latest item without knowing the exact time it was written, it's not suggested to ever use a timestamp for a partition key. Below I suggest an alternative data model to suit your needs:

And your Lambda function will look like this:

import boto3
session = boto3.session.Session()
dynamodb = session.resource('dynamodb')
table = dynamodb.Table('HomeDB')
def lambda_handler(event, context):
    response = table.query(
        KeyConditionExpression="#pk= :pk",
        ScanIndexForward=False,
        Limit=1, 
        ExpressionAttributeValues={
              ":pk": 1
        }, 
        ExpressionAttributeNames={
             "#pk":"pk"
        }
     )

    # Other business logic here

More details in this blogpost: https://aws.amazon.com/blogs/database/effective-data-sorting-with-amazon-dynamodb/

Hi,

This article is probably interesting for what you want to achieve: https://blog.jankosmala.eu/2018/10/20/aws-dynamodb-get-the-latest-item/

Best,

Didier