I am trying to Execute a procedure from talend. HAve tried using tSnowflakeInput, tSnowflakeRow but no luck.
As it results in "[WARN ]: org.talend.components.snowflake.runtime.SnowflakeRowReader - Query execution failed. Record was not processed.
net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error:
Unknown user-defined function EDP.Schema.PROC
I'm Calling the Procedure as "call Schema.Proc();" When executed in Snowflake, it runs fine. In Talend it displays the above exception.
Please advice on how to invoke this procedure from talend?
@VRM_5389, you need to use tsnowflakerow component and call the procedure.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables