Hi All,
I am new to snaplogic and my first task is to execute multiple Snowflake stored procedures via snap logic and log the execution of those stored procedures in a log table. Below values needs to be captured for each stored procedure.
Stored procedure name
Start Time
End Time
Total Time taken by SP
Execution status (Success / Fail)
Message (Success message / Error message)
I am able to do this via snow flake but for that I have to modify each and every stored procedure, which is not a feasible option.
Is there a way by which I can call one or multiple stored procedure in snaplogic at a time and populate log table explained above.
Thanks in advance.
Dinesh
