Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);