Can AWS GLUE handle LOADING tables with foreign key relationships ?

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

主題

分析資料庫

標籤

AWS Glue 提取轉換與載入資料

語言

English

rePost-User-3188796

已提問 1 年前檢視次數 369 次

2 個答案

最新
最多得票
最多評論

這些答案是否有幫助？支持正確答案，以幫助社區從您的知識中受益。

已接受的答案

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.

Ananth Tirumanur

已回答 1 年前

專家

Giovanni Lauria

已審閱 1 個月前

Thanks for the info

rePost-User-3188796

已回答 1 年前

Can AWS GLUE handle LOADING tables with foreign key relationships ?

相關內容