topic How to call snowflake procedure from Talend in Talend Studio

How to call snowflake procedure from Talend

abhi01 — Mon, 24 Apr 2023 10:52:05 GMT

Hi Team,

I am using Tsnowflakedbrow to call the procedure in snowflake but getting below error.

Exception in component tDBRow_1 (Snowflake_SP_Call) org.talend.components.api.exception.ComponentException: UNEXPECTED_EXCEPTION

The same is working fine when I directly call this procedure from snowflake.

Re: How to call snowflake procedure from Talend

Anonymous — Tue, 25 Apr 2023 00:54:01 GMT

Hello @not specified not specified ,

you need to use tSnowflakeRow component and call the procedure like

CALL temporary_db_qualified_names_test.temporary_schema_1.stproc_pi();

https://docs.snowflake.com/en/sql-reference/stored-procedures-usage.html

Re: How to call snowflake procedure from Talend

csong — Thu, 18 May 2023 16:45:30 GMT

How do you deal with failure of procedure? I have my procedure return "SUCCESS" if it is fine and returns exception info in JSON if failed. Or do I need to use the tDBInput and do a mapping with two flows?