Solved

How To execute a Snowflake Stored Procedure ?

  • 21 February 2022
  • 2 replies
  • 485 views

Is it possible to execute a custom SQL script (dynamic creation with parameters) or a stored procedure in snowflake ?
Thanks in advance.

icon

Best answer by Ranjith P 22 February 2022, 05:57

View original

2 replies

Userlevel 2
Badge

Hi @Philippe REY If you are using the latest version of Snowflake library, you can use the Snowflake Executor (in which you can run all the commands).

You can use this executor in StartEvent or StopEvent or with the Snowflake File Uploader destination.

OR you can try using the jdbc related available processors to this use-case.

(Please note that we did not test this jdbc with snowflake)

OR incase if you are looking to perform this stored procedure in the origin, you can try using the jython/groovy/javascript

Thank you @Ranjith P for all these details and advices

Reply