# Connect R studio to snowflake with single sign on? **URL:** \ **Category:** Software/Technology\ **Created:** [February 11, 2025, 7:07pm UTC](https://community.goactuary.com/t/connect-r-studio-to-snowflake-with-single-sign-on/9979 "2025-02-11T19:07:17Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![epistemus](https://community.goactuary.com/letter_avatar_proxy/v4/letter/e/bc8723/32.png) [@epistemus](https://community.goactuary.com/u/epistemus)\ **Post date:** [February 11, 2025, 7:07pm UTC](https://community.goactuary.com/t/connect-r-studio-to-snowflake-with-single-sign-on/9979/1 "2025-02-11T19:07:17Z")
Has anyone connected to Snowflake tables successfully through R studio? There seems to be some necessary installations > **[Snowflake Community](https://community.snowflake.com/s/article/How-To-Connect-Snowflake-with-R-RStudio-using-RODBC-driver-on-Windows-MacOS-Linux)** > > Join our community of data professionals to learn, connect, share and innovate together or > **[Accessing Snowflake with R | R-bloggers](https://www.r-bloggers.com/2022/02/accessing-snowflake-with-r/#google_vignette)** > > Snowflake is a well known cloud-based database. It’s used for Data Warehouses and other big data applications. In this article and the following ones I want to show how to setup and access a snowflake database from various clients such as R, Tableau... 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! ---
**Author:** ![Vorian\_Atreides](https://community.goactuary.com/user_avatar/community.goactuary.com/vorian_atreides/32/65623_2.png) [@Vorian\_Atreides](https://community.goactuary.com/u/Vorian_Atreides)\ **Post date:** [February 11, 2025, 7:34pm UTC](https://community.goactuary.com/t/connect-r-studio-to-snowflake-with-single-sign-on/9979/2 "2025-02-11T19:34:38Z")
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). ---
**Author:** ![ALivelySedative](https://community.goactuary.com/user_avatar/community.goactuary.com/alivelysedative/32/1337_2.png) [@ALivelySedative](https://community.goactuary.com/u/ALivelySedative)\ **Post date:** [February 11, 2025, 8:00pm UTC](https://community.goactuary.com/t/connect-r-studio-to-snowflake-with-single-sign-on/9979/3 "2025-02-11T20:00:31Z")
Not Snowflake specifically, but I have connected via ODBC to DB2…without asking permission…at one point. I would think it’s doable. ---
**Author:** ![Vorian\_Atreides](https://community.goactuary.com/user_avatar/community.goactuary.com/vorian_atreides/32/65623_2.png) [@Vorian\_Atreides](https://community.goactuary.com/u/Vorian_Atreides)\ **Post date:** [February 11, 2025, 8:52pm UTC](https://community.goactuary.com/t/connect-r-studio-to-snowflake-with-single-sign-on/9979/4 "2025-02-11T20:52:01Z")
> [@ALivelySedative](#): > > without asking permission…at one point. I would think it’s doable 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). ---
**Author:** ![Anomaly](https://community.goactuary.com/user_avatar/community.goactuary.com/anomaly/32/72607_2.png) [@Anomaly](https://community.goactuary.com/u/Anomaly)\ **Post date:** [February 23, 2025, 4:20am UTC](https://community.goactuary.com/t/connect-r-studio-to-snowflake-with-single-sign-on/9979/5 "2025-02-23T04:20:25Z")
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. ---
**Author:** ![Fish\_Actuary](https://community.goactuary.com/letter_avatar_proxy/v4/letter/f/3ec8ea/32.png) [@Fish\_Actuary](https://community.goactuary.com/u/Fish_Actuary)\ **Post date:** [February 26, 2025, 3:48am UTC](https://community.goactuary.com/t/connect-r-studio-to-snowflake-with-single-sign-on/9979/6 "2025-02-26T03:48:04Z")
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. ---
**Author:** ![epistemus](https://community.goactuary.com/letter_avatar_proxy/v4/letter/e/bc8723/32.png) [@epistemus](https://community.goactuary.com/u/epistemus)\ **Post date:** [March 7, 2025, 6:05pm UTC](https://community.goactuary.com/t/connect-r-studio-to-snowflake-with-single-sign-on/9979/7 "2025-03-07T18:05:38Z")
Thanks, and Welcome to GoActuary! Apt username for this forum!