topic Re: Talend tSnowflakeRow Component in Talend Studio

Talend tSnowflakeRow Component

Ani1 — Sat, 16 Nov 2024 03:08:10 GMT

Hi All,

I am doing an update operation (ELT) in tDBRow component for snowflake. There is a rowCount based commit, but no explicit commit option. My question here is: is there a specific component for Commit, or does Talend do an auto commit, eliminating the need for a commit interval/ commit component.

Regards,

Anirudh

Re: Talend tSnowflakeRow Component

Anonymous — Sat, 29 Feb 2020 10:34:05 GMT

Hi
The Snowflake commit and rollback components are available since v7.3.1, see
https://jira.talendforge.org/browse/TDI-41954

So, please download the latest version 7.3.1 and test them.

Regards
Shong

Re: Talend tSnowflakeRow Component

Ani1 — Mon, 02 Mar 2020 08:18:41 GMT

Please share the link for 7.3.1

Re: Talend tSnowflakeRow Component

Anonymous — Mon, 02 Mar 2020 11:48:14 GMT

HI
If you are using community version, go to the download page.
https://www.talend.com/download/?utm_medium=talendcommunity&utm_source=community_navmenu&_ga=2.256453963.1747797762.1582457680-680381362.1566008802

Regards
Shong

Re: Talend tSnowflakeRow Component

Anjali3 — Thu, 05 Mar 2020 21:47:40 GMT

Hi ,

Im using talend cloud 7.2.1 version. Does the snowflake components in this version have autocommit option ?

Re: Talend tSnowflakeRow Component

Anonymous — Fri, 06 Mar 2020 00:40:49 GMT

@Anjali, the changes will be commit automatically with 7.2.1, what is your concern?

Re: Talend tSnowflakeRow Component

Anjali3 — Thu, 16 Apr 2020 16:53:34 GMT

Im using proxy for talend snowflake connection. and loading a csv file to tsnowflake output component. tables are created using this flow, but however records are not getting inserted. looks like its not commiting. im using the existing connection in output component.

Note : Im able to insert the records in same table using tsnowflakerow component , since there was a commit option in this component.

Please help.Do i enable any option to commit the DML action in tsnowflake output component (when using a connection from tsnowflakeconnection component).

Thanks

Re: Talend tSnowflakeRow Component

manodwhb — Fri, 17 Apr 2020 00:49:38 GMT

If you have not enabled auto commit in tdbconnection then you need call tdbcommit component separately after tdboutput using on component OK.