cancel
Showing results for 
Search instead for 
Did you mean: 

oauth Connection to Snowflake

oauth Connection to Snowflake

Hi Team,

 

I am trying to Connect Snowflake to DataRobot, where as in snowflake we only allow sso access. I am trying to find tutorial for Datarobot with Snowflake oauth Connection but cannot find any. Can any body please suggest a tutorial link or blog where I can connect datarobot with Snowflake with oauth.

 

Thanks in advance

1 Solution

Accepted Solutions

Hi @dandev ,

Unfortunately, Snowflake SSO support is not publicly available yet at this point. We’re actively working on this to make it available later this year. 

View solution in original post

12 Replies
Linda
DataRobot Alumni

Hey @dandev I know the community is hunting down an answer for you!

Hi @dandev ,

Unfortunately, Snowflake SSO support is not publicly available yet at this point. We’re actively working on this to make it available later this year. 

Thanks everybody for the help

0 Kudos

I wanted to propose some alternatives:

  1. A service account that is locally authenticated and able to be used for this exercise
  2. A password being set for your account so it could leverage local authentication as well
  3. If neither of these are allowed, one could pull the data out to somewhere else (like a .csv) then upload it to DataRobot.  This could be done manually, or programmatically; using python to query Snowflake data and importing DataRobot's Python SDK to push the data into DataRobot as well.  This is the PUSH option demonstrated at the start of this article: DataRobot & Snowflake: Project Creation

@HajimeO I am actually looking for oauth setup in datarobot to snowflake. Is that is also under process. If so then can u please share a link which I can show to my client

0 Kudos

@dandev If I understand your question correctly, the answer is yes. We are working to support connecting to Snowflake that is configured with SSO using OAuth. There are no links where we officially state this, though.

Hi @HajimeO ,

 

Has this been implemented yet?

 

Kind regards,

 

Lorcan

Hi @Lorcan 

External OAuth for Snowflake data connection is now available as public preview:

https://docs.datarobot.com/en/docs/release/public-preview/data-preview/extoauth-snowflake.html

This means that, if you are a paid SaaS customer (have active DataRobot SaaS subscription), you can contact DataRobot Support to enable the feature. If you are a trial user / self service user, it will be available when the feature becomes Generally Available (GA). The schedule for this feature to go GA is not determined yet. 

0 Kudos

Hi @HajimeO,

 

I am using the DataRobot python API, which according to the docs has an OAuth credential. So there is no way of using this unless I am a SaaS customer?

 

Kind regards,

 

Lorcan

0 Kudos