idea Allow for Snowflake Target to specify Storage Integration instead of Key and SAS Token in Suggest an Idea

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

DataGuyAtHeart — Tue, 01 Sep 2020 21:34:29 GMT

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

Re: Allow for Snowflake Target to specify Storage Integration instead of Key and SAS Token - Status changed to: Open - On Roadmap

Ola_Mayer — Mon, 28 Sep 2020 21:17:36 GMT

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

DataGuyAtHeart — Tue, 29 Sep 2020 12:12:11 GMT

Excellent news. Thanks!

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

dmk22 — Thu, 15 Jul 2021 14:35:24 GMT

Super pumped for this to be completed! Thank you!

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

DataGuyAtHeart — Thu, 15 Jul 2021 14:45:39 GMT

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

Thanks!

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

friendlyadmins — Mon, 30 Aug 2021 02:10:10 GMT

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.

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

Meghann_MacDonald — Wed, 02 Aug 2023 15:02:12 GMT

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.

Re: Allow for Snowflake Target to specify Storage Integration instead of Key and SAS Token - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:02:14 GMT