SNOWFLAKE component tsnowflakeout not working

NS1657544567 — Fri, 15 Nov 2024 22:44:12 GMT

Having issue in using tsnowflakeout in my job. I have two jobs - Job 1 sourcing from MS SQL server database and write to snowflake, Job 2 does same but sources from a delimited file. In both jobs data extraction from source work if I have target as tlogrow or a delimited file as target, as soon as I switch it to tsnowflakeout, jobs finishes with code exit 0 however it doesn't do anything, even extraction that was working before stops fetching any data. snowflake connection on component (built-in) works fine, I can see it connects to snowflake database/schema and retrieves metadata of the table and shows table and structure in Talend studio. But during execution nothing happens, no errors, and no data extraction or writing to target , job finishes within seconds. Also to mention, every time I add snowflake component, next time when I open studio I can't retrieve existing jobs with snowflake components, seeing below error,

An error has occurred. See error log for more detailsor .

JsonIoException setting field 'status' on target: OK null with value: {name=null}

Does open studio support writing to Snowflake? or need different Talend product. I am new to talend please help in resolving above issues or any suggestions on product i need to use to integrate with Snowflake.

Re: SNOWFLAKE component tsnowflakeout not working

Anonymous — Fri, 15 Jul 2022 07:58:33 GMT

Hello,

Could you clarify in which Talend version/edition you are? Is your snowflake connection OK with you? You are able to define connectivity to a Snowflake cloud instance under the Metadata > Snowflake node in the Repository of your Studio.

Please have a look at this online documentation about: TalendHelpCenter: Creating a Native Connection to Snowflake

Best regards

Sabrina

topic Re: SNOWFLAKE component tsnowflakeout not working in Talend Studio

SNOWFLAKE component tsnowflakeout not working

Re: SNOWFLAKE component tsnowflakeout not working