topic Re: Trigger Snowflake Stored procedure from Talend in Talend Studio

Trigger Snowflake Stored procedure from Talend

Sujan123456 — Sat, 16 Nov 2024 00:07:40 GMT

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 — Tue, 25 May 2021 01:44:32 GMT

@Su has Y , You need to use tsnowflakerow component and call the procedure.

CALL temporary_db_qualified_names_test.temporary_schema_1.stproc_pi();

Thanks,

Manohar

Sujan123456 — Tue, 25 May 2021 02:11:37 GMT

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.