Question
In the setting of Execute COPY Command operation in the Amazon Redshift connector, there is an item [COMMIT if command successfully finishes] and I understand that it is only possible to perform transaction on per icon basis placed in a script from the description in the documentation.
I would like to commit the results only when all Execute COPY Command operations for multiple tables have completed successfully, is this possible?
Answer
The Amazon Redshift connector supports not only transaction processing with a single icon, but also [transaction] operation and transaction control through script property settings.
Therefore, it is also possible to implement transaction processing with multiple Execute COPY Command operation as a single unit of transaction.
Note that the Amazon Redshift connector and JDBC connector connections to Amazon Redshift are separate sessions, therefore common transactions cannot be applied to both of them.
If you want to use the same transaction as the JDBC connector connection to Amazon Redshift, you need to execute COPY command with the JDBC connector as well.
For more information on the Amazon Redshift Connector, please refer to the following manual page.
Execute COPY Command - Amazon Redshift Connector
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/amazonredshift_exec_copy_command.htm
Related FAQs
JDBC connector - How to set up connection resource and use connector
https://support.square.hulft.com/hc/articles/11766532369940
Comments
0 comments
Article is closed for comments.