Uploading JSON file to a new column in DynamoDB table

Question

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?

Comments

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
FROM x
INNER JOIN y ON x.id=y.id;