DynamoDB Manipulation Scripts

Multiple local scripts used to manipulate the database & modify/add records quickly.

Contributors

• Ethan Kuai (2026-27 Database Officer)

Set-up

# first install awscli2
pip install boto3 python-dotenv
aws configure

In AWS, go to Configuration > Permissions > Execution Role > Policy > Allow dynamodb:Scan, dynamodb:Query, dynamodb:UpdateItem.

I (Ethan) have created policy DynamoDB_MassUpdateRegistrants_Policy which does as such. So create a new user/use existing user which has the above policy permission.

Usage

Simply python3 <file>.py.

All environmental variables are stored within .env, not synced to repo. Database name etc are all obscured.

It is better to use session = boto3.Session(profile_name=) but unnecessary for now.