Uploading JSON file to a new column in DynamoDB table

0 votes
Actually I have two dynamo db tables where one of the table's columns should be added as a new column of another table based on the primary key. Both the tables contain same column names except for one. How can I map both the tables and finally output one single table which have all the columns. Can someone help me with this?
Mar 6, 2020 in Python by Naveena

Hey @Naveena,

You can try this:

Joining tables is a fundamental principle of relational databases. In your case, x and y are related with the id column.

SELECT x.id, x.name, x.num, y.date, y.roll
INNER JOIN y ON x.id=y.id;

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.