1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
Not out of the box at this time, the way to do it is a custom code node that writes into a Postgres temporary table and then issue a SQL command to do the upsert/merge into the final table (using JDBC, the psycopg2 library or similar).
관련 콘텐츠
- AWS 공식업데이트됨 3달 전
- AWS 공식업데이트됨 2년 전
- AWS 공식업데이트됨 일 년 전
can we use 'Custom Transform' to make it? or do i have use in seperate to do it?
Yes you can, despite the name "transform" you can put any code, including writing
sorry sir, i'm new at here. I think I get your idea, but I want to confirm a few things. This means that after I perform transformations on my data, I have to create a script to perform an upsert query into my table. My next question is whether I can set the connection/target table directly from the script? this is a simple flow image that I have created, and I want to make sure that we line up this 'custom transform' can be used for the script code requirements above.
https://ibb.co/C64kp2q
Your custom transform node has to be part of the graph, it should be the last node and you do the writing/updating there. That's it