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.
@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.
