I’ve spent the last year working with AWS DynamoDB from within Unreal. Similar HTTP request with Json data approach.
The header signing process took me a while. If I were to start from scratch I’d take a much harder look at integrating a library to do it (think that the open source lib would be where I’d start looking).
No idea how the AW services map to your problem, but they definitely scale well!