Showing results for 
Search instead for 
Did you mean: 

How to log snowflake store procedure execution logs in a log table via snap logic

New Contributor

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.