× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Lwaugh reported 2019-06-07T13:23:07Z  · MounikaSure last modified 2020-04-15T04:43:25Z

Login support for ADFS SSO for Snowflake


Priority Low
Complexity Unknown
Component DB - Snowflake
Version 20.6

Current ADS login uses Snowflake’s internal password – Customer would like to use ADFS SSO to authenticate.

The below assumes that Snowflake 3.10.3 drivers is installed as part of this release of ADS. See issue #15754

We need to add a separate switch for ADSF authentication in the Snowflake server properties.

1) Snowflake Server properties should have a selection dropdown in the authentication area like Hive. 
   1) Default - Normal Snowflake authentication
   2) SSO
2) When SSO is selected 
   1) We should gray out password in the server properties
   2) Add &authenticator=externalbrowser to the end of the url automatically in ConnectionProperties->generateURL
3) We should add a checkbox in options under SSO to delete persistent tokens in storage when ADS is closed.
4) Add -Dnet.snowflake.jdbc.temporaryCredentialCacheDir=USER_HOME\.datastudio -Dnet.snowflake.jdbc.ocspResponseCacheDir=USER_HOME\.datastudio to ADS code base when starting ADS. to
identify where persistent tokens are stored.
 
After applying the attached patch, you can download the attached connection files set up with ADFS SSO as PARTNER5, PARTNER6 and PARTNER7. SSO password will be give to you separately.
 
15 attachments

Issue #15719

Verified
Fixed
Resolved 2020-02-27T13:34:11Z
 
 
Completion
No due date
Fixed Build ADS 20.6.0-dev-30-no-ofsc
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017