Can AWS GLUE handle LOADING tables with foreign key relationships ?

Question

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

Now how to load these two tables using AWS GLUE ?

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

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.

Answer

Thanks for the info

Can AWS GLUE handle LOADING tables with foreign key relationships ?

Contenuto pertinente