Installing the Snowflake ODBC driver for use with RStudio professional products

RStudio Professional Drivers is a free add-on that is only available for use with RStudio Server Pro, RStudio Connect, and Shiny Server Pro. Download or use of RStudio Professional Drivers is governed under the terms of the RStudio End User License Agreement. By downloading you agree to the terms posted here.

These instructions will install the release candidates of the next version of ODBC drivers including the Snowflake driver. The current general release of RStudio Professional Drivers does not include an ODBC driver for Snowflake. However, the next driver release will include Snowflake. If you are using RStudio Server Pro or RStudio Connect and you want access to the Snowflake drive today, then you can follow these instructions.

Disclaimer: These drivers have not been certified, so they are not fully supported at this time. Please contact support@rstudio.com for more information.

Uninstall the existing drivers

As of version 1.6.1, the drivers are packaged as an rpm or deb. If you previously installed the v1.6.1 drivers, you should uninstall them.

sudo yum remove rstudio-drivers

If you are using an older version of the drivers, we recommend removing them also. See our docs for more information.

Download the drivers (v1.7 release candidates)

Download the appropriate version of the drivers for your Linux distribution (i.e. RedHat, Ubuntu, SLES 12, SLES 15).

curl -O https://drivers.rstudio.org/7C152C12/installer/rstudio-drivers-1.7.0_rc2-1.el7.x86_64.rpm
curl -O https://drivers.rstudio.org/7C152C12/installer/rstudio-drivers_1.7.0-rc2_amd64.deb
curl -O https://drivers.rstudio.org/7C152C12/installer/rstudio-drivers-1.7.0_rc2-1.sles12.x86_64.rpm
curl -O https://drivers.rstudio.org/7C152C12/installer/rstudio-drivers-1.7.0_rc2-1.sles15.x86_64.rpm

Install the drivers

Install the appropriate version of the drivers for your Linux distribution (i.e. RedHat, Ubuntu, SLES 12, SLES 15).

sudo yum install rstudio-drivers-1.7.0_rc2-1.el7.x86_64.rpm
sudo gdebi rstudio-drivers_1.7.0-rc2_amd64.deb
sudo zypper --no-gpg-checks install rstudio-drivers-1.7.0_rc2-1.sles12.x86_64.rpm
sudo zypper --no-gpg-checks install rstudio-drivers-1.7.0_rc2-1.sles15.x86_64.rpm

Configure your driver manager

Copy the contents of odbcinst.ini.sample into /etc/odbcinst.ini.  The sample configuration file in /opt/rstudio-drivers/odbcinst.ini.sample is preconfigured with the names and locations of the RStudio Professional Drivers.

See also

For detailed instructions on installing and configuring drivers, see our docs.