Feature Request: Snowflake with Okta authentification

[mkhudon]

My company uses Okta to authenticate when login in to Snowflake. Would it be possible to add support for this in SQLPro Studio?

Refer to this article for more information: https://community.snowflake.com/s/article/Okta-SSO-with-Snowflake-Part-2-JDBC-SQL-Tools

Thanks!

macOS 10.15.4
SQLPro Studio 2020.35 (Build 110664)

[hankinsoft]

Hi, A few questions: If you specify an authenticator: 1. Do you still enter a username and password? 2. Are you prompted with a SSO dialog within the current app you are using? (Could I get a screenshot or video of this if possible)? Thanks!

…

On Wed, Apr 8, 2020 at 1:00 PM Mathieu Kittel-Hudon < ***@***.***> wrote: My company uses Okta to authenticate when login in to Snowflake. Would it be possible to add support for this in SQLPro Studio? Refer to this article for more information: https://community.snowflake.com/s/article/Okta-SSO-with-Snowflake-Part-2-JDBC-SQL-Tools Thanks! macOS 10.15.4 SQLPro Studio 2020.35 (Build 110664) — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#406>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAYDTUCTNSDCPFRGBZMBTWTRLSNRHANCNFSM4MEBKQ7Q> .

[mkhudon]

Hum… Maybe I am configuring this incorrectly. Where would I specify the authenticator? I don't see the option in the connection window.

[hankinsoft]

Sorry, I meant if you specify one in another app :) I saw from the first link you provided how to you would specify the connection in a JDBC connection string, but I was looking for more info on what happens after that.

…

On Wed, Apr 8, 2020 at 2:10 PM Mathieu Kittel-Hudon < ***@***.***> wrote: Hum… Maybe I am configuring this incorrectly. Where would I specify the authenticator? I don't see the option in the connection window. [image: Snowflake Settings] <https://user-images.githubusercontent.com/93592/78812962-49e6ac00-799a-11ea-98f9-3b3f53ffaaa6.png> — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#406 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAYDTUE3XMQRWDFCMS63NRDRLSVY5ANCNFSM4MEBKQ7Q> .

[mkhudon]

Ah! No, I haven't tried with another app. I have been using the Snowflake web interface for now, but I would prefer using SQLPro if I could. :)

[hankinsoft]

Ahhhh ok. I opened a support request on the snowflake c library to see if it supports authenticators (snowflakedb/libsnowflakeclient#193). The answer to if I can support it, depends on this.

…

On Wed, Apr 8, 2020 at 2:22 PM Mathieu Kittel-Hudon < ***@***.***> wrote: Ah! No, I haven't tried with another app. I have been using the Snowflake web interface for now, but I would prefer using SQLPro if I could. :) — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#406 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAYDTUEXKLF7DEIABV277BLRLSXEHANCNFSM4MEBKQ7Q> .

[hankinsoft]

• Current libsnowflakeclient does not support this. Unfortunately I won't be able to add support for the time being.

[mkhudon]

That's too bad. Thanks for following up.

[hankinsoft]

No problem! Sorry for the bad news. I'm going to close this issue for the time being as its not something I'm going to be able to currently implement. I'll re-evaluate later on and see if libsnowflakeclient adds additional support.