1回答
- 新しい順
- 投票が多い順
- コメントが多い順
0
You can but you would need a separate read and a join.
So you would insert into the table, then read the table with t he generated ids, then join with the child data and finally insert into the child table using the generated ids.
関連するコンテンツ
AWS公式更新しました 2年前- AWS公式更新しました 3年前
Thanks. I'm ok with having a separate read. But it doesn't seem the aws glue visual editor allows me to add child nodes to the data target "postgres" node in which I'm doing the first insertion. How would I achieve this?
Yes, that's a visual job limitation, you would need to either have two visual jobs in workflow or use a custom code node to write and read again (you could copy the code generated from the original sink/source)
Good advice. Thanks a lot