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
822 views

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;

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.
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP