Talend tSnowflakeRow Component

[Ani1]

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

[Anonymous · Accepted solution]

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

[Ani1]

Please share the link for 7.3.1

[Anonymous]

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.25645...

Regards
Shong

[Anjali3]

Hi ,

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

[Anonymous]

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

[Anjali3]

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

[manodwhb]

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