How to Call a Snowflake Procedure from Talend

VRM_5389 — Mon, 01 Jun 2020 17:57:24 GMT

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?

Re: How to Call a Snowflake Procedure from Talend

manodwhb — Tue, 02 Jun 2020 06:28:00 GMT

@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

topic How to Call a Snowflake Procedure from Talend in Talend Studio

How to Call a Snowflake Procedure from Talend

Re: How to Call a Snowflake Procedure from Talend