Transaction management using Tsnowflake components

[Srini1256]

Hello ,

I am trying to implement transaction management using tSnowflake components in Talend. Please advise if there are any recommendations .

Though tSnowflakeconnection has the option to deselect 'AutoCommit' , that seems not going to work with tSsnowflakeOutput.

I am trying to load a file into Snowflake and if for some reason the job fails , I want to rollback the whole transaction. (Version 7.3.1).

Thanks

[Anonymous]

Hello,

Starting from V 7.3.1, we have added new option "commit every" on tSnowflakeConnection, tSnowflakeCommit and tSnowflakeRollBack. You are able to to control transaction logic during reading/writing data to SnowFlake with the help of tSnowflakeCommit, tSnowflakeRollBack components.

Best regards

Sabrina

[Srini1256]

Hi Sabrina,

I have 7.3.1 . But I don't see those options in my version. Using tSnowflakeCommit/Rollback for some reason, not working .

Have you used these components ?

Please let me know .

Thanks

Srini