How to Call a Snowflake Procedure from Talend

[VRM_5389]

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?

[manodwhb]

@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