By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re: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 2 years ago630 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 2 years ago
profile picture
EXPERT
Giovanni Lauria
reviewed a year ago
0

Thanks for the info

rePost-User-3188796
answered 2 years 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