OAC DV to Snowflake using SSO

User_SK2UI

Organization Name

Wyndham

Description

Right now we are conectng to Snowflake using SNF connector from OAC . But we cannot pass SSO credentials to Snow flake connection . We can only pass local snowflake login credentials . But in our company we cannot create any logins in SNF .

Let us know if there is any way to enable OAUTH authentication inSNF connector

Use Case and Business Need

Users create their own Snowflake connection using their credentials which is recommended to enable user level security . But users cannot create connection using their SSO credentials (OKTA) . 

Original Idea Number: 2c8b53348a

Ciaran

This is a must for large organizations who use the likes of PingIdentity for securing their platforms.

We have this as an open issue and causes issues for adoption regarding our enterprise security.

https://www.pingidentity.com/en/resources/identity-fundamentals/authentication-authorization-standards/oauth.html

Ciaran

BTW this should be for any database / source connection definition across the analytics suite... not just the DV component.

Dave Rynne

Any update on this? Would love to see an SSO solution from OAC to Snowflake.

Ciaran

Yes would love to know.... This is a serious gap for large enterprise user communities.

You must provide a free text key value par capability as well.

Many organizations stuck on this point.

Sean McArthur

Has anyone found a solution to this? We are rapidly moving to SNF and need to find a workaround for SSO and/or passing user creds to SNF.

Dave Rynne

with snowflake looking to deprecate password only accounts, this could be a major issue, unless I'm missing something!

FAQ: Snowflake Will Block Single-Factor Password Authentication