Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Allow for Snowflake Target to specify Storage Integration instead of Key and SAS Token

DataGuyAtHeart
Contributor III
Contributor III

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.

Here is the link on this: https://docs.snowflake.com/en/sql-reference/sql/create-storage-integration.html

7 Comments
Ola_Mayer
Employee
Employee
 
Status changed to: Open - On Roadmap
DataGuyAtHeart
Contributor III
Contributor III

Excellent news. Thanks!

dmk22
Contributor
Contributor

Super pumped for this to be completed!  Thank you!

DataGuyAtHeart
Contributor III
Contributor III

@Ola_Mayer any further updates on when this will be available?  The expired token hit us again the other day.

Thanks!

friendlyadmins
Contributor
Contributor

Any updates on this?

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.

Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

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.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived