Qlik Community

Suggest an Idea

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Support for OAuth with Snowflake as an Endpoint

spachunuri
Contributor III
Contributor III

Support for OAuth with Snowflake as an Endpoint

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.

5 Comments
EyalSilner
Employee
Employee
 
Status changed to: Open - New
Shelley_Brennan
Employee
Employee

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

Status changed to: Open - Collecting Feedback
spachunuri
Contributor III
Contributor III

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.

DWH2Go
Contributor III
Contributor III

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.

Shelley_Brennan
Employee
Employee

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

Status changed to: Open - On Roadmap