Connect R studio to snowflake with single sign on?

The Sandbox Software/Technology
1

Has anyone connected to Snowflake tables successfully through R studio?

There seems to be some necessary installations

or

My caveat to this situation is we utilize single sign-on for snowflake access.

Has anyone been able to get this to work? I need IT’s help to install the ODBC driver into the system DSN system of the ODBC connections, 64 bit, i think.

Thanks!

2

I wonder if you can do SSO with an ODBC connection. I know that ODBC tends to be associated more with “older” versions of databases (like DB2 or Access); and that JDBC connections can query against an SSO source for authentications.

But I’m not a data engineer (just someone who does both sorts of connections and know that what is done in each case).

3

Not Snowflake specifically, but I have connected via ODBC to DB2…without asking permission…at one point. I would think it’s doable.

4

If the database doesn’t require authentication–or the authentication is “static” and you can program the credentials in to the connection info–then you’ll not need an explicit authentication step to connect.

By “static”: the ID/password doesn’t require being changed on a fixed cadence (like every 60 days).

5

Yes, but I had to be whitelisted through our company’s authentication servers in order for it to allow me to use SSO without having an additional manual authentication step.

1 Like
6

One thing to note with ODBC is that you need to choose a database engine that aligns with your version of R. You need to use 64 bit with 64 bit, it doesn’t go well if you mix 32 but and 64 bit

If you have access to copilot or some version of AI try asking it for guidance. I’ve been surprised at how useful its been for some of my R issues.

2 Likes
7

Thanks, and Welcome to GoActuary! Apt username for this forum!