Oracle Communities

Oracle Analytics and AI

Child Item

OAC DV to Snowflake using SSO

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

Find more posts tagged with

Data Connectivity

Analysis and Data Visualization

Needs Votes

Status: Needs Votes

Comments

User_SK2UI

I understand that we can pass Key Pair authentication when creating direction DV connection . But we are connecting to Snowflake via RPD . Can we pass Key-pair authentication value in connection string or not ?

Joseph Reed

For our connection to Snowflake in the RPD we have switched from using a username/password to using a username/PAT (https://docs.snowflake.com/en/user-guide/programmatic-access-tokens) which will still be supported going-forward. After the PAT is set up in Snowflake, you would simply just replace your password with the PAT (it's just a long alpha-numeric string) in the RPD connection. The key-pair authentication doesn't really gain us anything in regard to our use case. OAuth will be the ideal solution.

Ciaran

We're currently having PAT approach reviewed from a security perspective… I don't see how this would be acceptable given that it's still a shareable "Password" in another form.

OAS in it's current state does not support OAuth and even at that I don't see how OAC it supports the configuration of encrypted key passwords.. still seems to be a gap.

We're trying to configure a JDBC / ODBC based connections, this might be a good stepping stone.

We really need Oracle to produce a guidance document / response to the Snowflake Situation.

Full support of OAuth & Key Pairs for: Repository, Weblogic Console and Publisher based connections.

Oracle really needs to enable plain open text key pair type configuration screen for all areas so we can configure data sources and connection drivers without being dependent on the GUI restrictions that current exist.

Sean McArthur

Oracle is working on a native OAUTH support for a Snowflake connection in their roadmap as an upcoming feature, but haven't heard of any specific timelines.

https://community.oracle.com/products/oracleanalytics/kb/articles/32-product-roadmaps

Brendan T

There's a growing need for this feature

Ciaran

I see this one as a massive gap.

Oracle are behind the security curve on this one, and need to get moving on it. Customers are disabled as a result. Even after escalating via support.

"Oh look there's another BI vendor that does it no problem…. "