idea Re: Support for OAuth with Snowflake as an Endpoint in Suggest an Idea

Support for OAuth with Snowflake as an Endpoint

spachunuri — Wed, 16 Dec 2020 09:24:03 GMT

Currently Replicate only supports Snowflake native accounts for Authentication. We would like to have OAuth method to connect to Snowflake as an Endpoint. More tools are going towards OAuth method which is more secured than this native accounts.

Re: Support for OAuth with Snowflake as an Endpoint - Status changed to: Open - New

EyalSilner — Mon, 28 Dec 2020 13:00:00 GMT

Re: Support for OAuth with Snowflake as an Endpoint - Status changed to: Open - Collecting Feedback

Shelley_Brennan — Mon, 28 Dec 2020 14:22:37 GMT

Thank you for the suggestion. We would like to collect more feedback on this request. Also, could you let us know specifically which options you would need support for: https://docs.snowflake.com/en/user-guide/oauth-intro.html

Re: Support for OAuth with Snowflake as an Endpoint

spachunuri — Thu, 31 Dec 2020 07:51:27 GMT

Hi Shelly. Thank you so much. Preferebly OAuth as that is the way most of the other leading tools are going as this is more secured. As an example. A user originates from Microsoft Azure AD (Gives level 1 security that all users activity is monitored by SECOPS) and then adding OAuth on top of this adds level 2 security. We are currently using Talend for our ETL/ELT and Spark jobs where it uses OAuth way of Authenticating to Snowflake. We have already integrated Azure AD and enabled on OAuth on Snowflake. It would be just giving this option from Qlik to be able to use this.

Lately SECOPS teams across the companies are against using Native accounts as they are way easy to misuse if we know the password. Also, if we do use Native Accounts they suggest to use some kind of Key Authentication tools like Azure Key vault which is also not yet supported with Replicate. I have another idea on the KeyVault.

Let me know if you have any questions.

Re: Support for OAuth with Snowflake as an Endpoint

DWH2Go — Mon, 18 Jan 2021 23:28:58 GMT

Great suggestion! We absolutely need OAuth 2.0 support for both Replicate and Compose - the only alternative is to use SF (non-federated) accounts. The Snowflake browser already integrates with Azure Active Directory (AAD), and other ETL tools use OAuth for programmatic access. In our case, we'd need Qlik to connect to AAD over Azure private link.

Re: Support for OAuth with Snowflake as an Endpoint - Status changed to: Open - On Roadmap

Shelley_Brennan — Fri, 23 Jul 2021 18:20:39 GMT

This is on the Replicate roadmap. We will update when we get closer to development and delivery. Thank you!

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

Meghann_MacDonald — Wed, 02 Aug 2023 16:34:16 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: Support for OAuth with Snowflake as an Endpoint - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 16:34:18 GMT