Solved

How To execute a Snowflake Stored Procedure ?

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

Best answer by Ranjith P

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.

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

Did this topic help you find an answer to your question?

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.

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

Sign up