Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
NS1657544567
Contributor
Contributor

SNOWFLAKE component tsnowflakeout not working

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.

Labels (3)
1 Reply
Anonymous
Not applicable

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