Skip to main content

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

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