Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have created an stored procedure in
snowflake
for finding duplicated rows.The procedure inserts log info into my log table while running and the result of the stored procedure is boolean (true if there are duplications/false if there aren't)
I'm trying to run this procedure but without success.
In general i cant make the job run my SP and also didn't had success in inserting the boolean result to the log table (even added tmap component for trying mapping the output to one of the columns in my log table but failed).
It seems Talend don't recognize the SP or the output of the SP.
Im not sure if the SP is running or not.
As you can see in the screen shots, I called the SP and in the tMap there is no column on the left (like there is no output from SP).
Can someone assist please?
Regards
Hello,
Are you able to use tsnowflakerow component and call the procedure?
https://docs.snowflake.com/en/sql-reference/stored-procedures-usage.html
Best regards
Sabrina