Allow for Snowflake Target to specify Storage Integration instead of Key and SAS Token
One of the Key Features of Snowflake is storage integration between Snowflake and the Blob Storage vendor. This is a tighter integration with not needing to pass tokens and keys.
We have setup storage integration on the snowflake side, when using an Azure Storage blob from qlik it creates a new stage without specifying the storage integration. I discovered we can set the storage integration on the snowflake side by modifying the stage qlik creates, this works, however the storage integration field gets overwritten whenever the job restarts.
Having to use SAS tokens presents a management overhead to track and manage the life of the tokens as well as a security risk if the tokens get compromised.
Obviously a fair bit of work and testing involved in this but could you add a field in the qlik console to set the storage integration name and have your stage use that supplied name? Setting the integration name from the snowflake side works so if you can define it from QLIK replicate then that should work too.
NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.