Call Snowflake procedure from Talend job

amba1 — Fri, 15 Nov 2024 23:33:05 GMT

Hello,

In snowflake, I call my procedures to calculate some durations using the following command: call CALCULATEDURATION();

How can i call that procedure out of a job?

For postgres, I used tdbrow and it worked fine, but tsnowflake row does not seem to work

[ERROR]: org.talend.components.snowflake.runtime.SnowflakeRowStandalone - Query execution has failed. Please validate your query.

net.snowflake.client.jdbc.SnowflakeSQLException: Stored procedure execution error: Scoped transaction started in stored procedure is incomplete and it was rolled back.

best regards

Re: Call Snowflake procedure from Talend job

Anonymous — Fri, 05 Nov 2021 05:17:55 GMT

@Not defined Not defined there is no a dedicated component for calling Snowflake procedure like other DB types, try the suggestion by manodwhb in this post.

Regards

Shong

topic Call Snowflake procedure from Talend job in Talend Studio

Call Snowflake procedure from Talend job

Re: Call Snowflake procedure from Talend job