How to call snowflake procedure from Talend

[abhi01]

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.

[Anonymous]

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 

[csong]

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?