Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
CALL temporary_db_qualified_names_test.temporary_schema_1.stproc_pi();
https://docs.snowflake.com/en/sql-reference/stored-procedures-usage.html