By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Can AWS GLUE handle LOADING tables with foreign key relationships ?

0

Trying to load tables from single source.. Source has data for EMP NAME , ADDRESS … target table A has EMP ID(Auto generated PK) and EMP NAME … table B has EMP ID(foreign key) ADDRESS ID ( Auto generated PK) AND ADDRESS…

Now how to load these two tables using AWS GLUE ?

No proper notes any where for this… can you help clarify

Topics
AnalyticsDatabase
Tags
AWS GlueExtract Transform & Load Data
Language
English
rePost-User-3188796
asked a year ago351 views
2 Answers
0
Accepted Answer

Glue does not have in built functionality that does this.

When you generate the ID, you can store it both the EMP NAME and EMP ADDRESS datasets and load the 2 tables with that information.

profile pictureAWS
Ananth Tirumanur
answered a year ago
profile picture
EXPERT
Giovanni Lauria
reviewed 24 days ago
0

Thanks for the info

rePost-User-3188796
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content