Execute Snowflake stored procedure from Post Loading ETL

[RoelT]

Hi,

We are using Snowflake for the datawarehouse.

According to the Compose documentation I should be able to execute a stored procedure from a custom ETL script. 

See point 8 at : https://help.qlik.com/en-US/compose/May2022/Content/ComposeDWDL/Main/DW/Data%20Warehouse/create_cust...

However, this option is not available to me in the ETL script editor. Is this option not available when the datawarehouse resides on Snowflake? Or is it some setting that I'm missing?

Roel

[RoelT · Accepted solution]

This was a non-issue.

I just needed to grant the user usage permissions on the stored procedure in Snowflake and execute the command from the etl script as:  CALL "DB"."SCHEMA".NAMEPROCEDURE(PARAM1, PARAM2);