How does the Retry component behave on a failure when it is applied to an orchestration job with BEGIN and COMMIT used to create Redshift transaction?

Matillion ETL
1

 If failure occurs between BEGIN and COMMIT, and first run fails, what happens to the transaction ? does it end or remains open with the possibility of causing a lock with next run or other jobs requesting the same resources ? Any information about this will be useful. Thanks.

2

@rvashist1586931863772​ could you please explain little clearly that would help me to understand and give a solution to your question.

3

He @HariRamK​ - Thanks for responding to my question. I have resolved this for myself. FYI- I found out that the transaction remains open when a failure occurs before commit. The retry component also fails. Therefore, I needed to add a rollback on failure for the retry component to work.

4

@rvashist1586931863772​ Oh that's great