topic Re: Transaction management using Tsnowflake components in Talend Studio

Transaction management using Tsnowflake components

Srini1256 — Sat, 16 Nov 2024 00:40:13 GMT

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

Re: Transaction management using Tsnowflake components

Anonymous — Mon, 08 Feb 2021 09:37:12 GMT

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

Re: Transaction management using Tsnowflake components

Srini1256 — Mon, 08 Feb 2021 19:40:02 GMT

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