Trigger Snowflake Stored procedure from Talend

[Sujan123456]

Hi All,

Could someone please guide me on how to invoke a stored procedure on snowflake from Talend studio.?

My workflow ends with data load to snowflake and then I added a tsnowflakerow component to execute stored procedure command.

Tsnowflakerow component is configured like the below.

Please guide/correct me as required.

Not worked much on Talend studio.

[manodwhb]

@Su has Y​ , 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 

Thanks,

Manohar

[Sujan123456]

Hello Manohar

thank you for taking time to respond.

I did try the way you suggested and used the tsnowflakerow component.

could you please check the screenshot shared that defines the values I have passed?

am I doing anything incorrect and hence not able to execute the SP via Talend.