Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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