cancel
Showing results for 
Search instead for 
Did you mean: 

oauth Connection to Snowflake

dandev
Image Sensor

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

Labels (1)
12 Replies
Anonymous
Not applicable

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

Hi @Lorcan , could you clarify which type of DataRobot deployment you are using?:

  • DataRobot SaaS (app.datarobot.com , app.eu.datarobot.com)
  • DataRobot Trial/Self-service (app2.datarobot.com)
  • DataRobot on premise / VPC (Your own domain)

Generally speaking, Python Client is available for all the three deployment types above. But this particular feature (Extern OAuth for Snowflake) is only available for DataRobot SaaS (the first one) at the moment.

0 Kudos

Hi @HajimeO,

I am using app.eu.datarobot.com

Thanks

Lorcan

0 Kudos

@Lorcan Then I think you have a valid subscription and should be able use the feature. Please reach out to DataRobot support contact and ask to enable it for your account. 

0 Kudos