dynamo | This is an experiment

I have a dataframe that looks like this:

And I'm trying to make it look like this:

I am using cloudformation template to build a dynamo db ( see below), once the stack builds successfully, I would like to alert/notify/trigger another aws resource, like a lambda function or a step function or a aws data pipeline to start such that I can start populating the dynamo. what is the best way to trigger another process or aws resource once cloudformation stack creation is successful ?

I am interested in returning all records with a given partition key value (i.e., u_type = "prospect"). But I only want to return specific attributes from each of those records. I have scraped together the following snippet from boto docs & Stack answers:

I am trying to query an autogenerated Amplify API using postman. I'm banging my head against the wall on something that should be simple. Can someone explain why this query URL doesn't return a JSON object?. The data exists in dynamo but returns an empty array in postman (and a 200 status):

POSTMAN (this is what I expected to work):

https://xxxxx.execute-api.us-east-1.amazonaws.com/staging/api/getShipContainer?location=fl

UPDATE after staring at the code for longer I see that req.params[partitionKeyName] is somehow evaluating to getShipContainer which would explain my issue, but how do I fix this? And why did it happen:

I am running DynamoDB locally using the instructions here. To remove potential docker networking issues I am using the "Download Locally" version of the instructions. Before running dynamo locally I run aws configure to set some fake values for AWS access, secret, and region, and here is the output:

I have an application that is in the us-east-1 region with following

I am using the AWS Dynamo DB library for Scala - com.amazonaws.services.dynamodbv2.

Earlier I had a table with a primary key and I was using GetItem to get specific item from it like so :

I am new to DynamoDB, and I have a small in house application, which will be used by my parents for their small business. I just have to keep records of 10 - 20 rows daily, and will have a few edits close to 5 - 10 at max. WIll I be able to use the Free Tier of Dynamo DB for the same?

I am using Heroku to host my LWC OSS (Node JS) application, which is again a free version. If not then any heads up to any particular type of Database which can fulfil my need.

I have a multi-tenant application and the backend comprises of the microservices. The tenant admin will have a preferences page on the UI that can store system preferences for the tenant (i.e all users of the tenant).

I am thinking about what the best place for storing this would be?

SSM or Dynamo? Any trade-offs here for this use case?

we have a tenant microservice or we could create a system preferences microservice to store the preferences. I am trying to avoid all cross-service communication so the user of each tenant will get all the preferences on login and will send them back in the header. Should we continue to store the preferences in the tenant DB or system preferences microservice is the way to go?