In the previous release we included a preview of the Snowflake driver. This new release provides full ODBC,
dbplyr, and Python support for Snowflake, as well as corrects some issues that occurred on new installations.
This release makes working with the Snowflake data cloud as easy as working with other supported data sources. For example, the same
dplyr syntax used with data in R will also work with data in Snowflake. In the code below, data from the
nycflights13 package were pre-loaded into a Snowflake data warehouse and then queried from R using the Snowflake ODBC driver. Notice that the same
dplyr syntax used here will also work on an R data frame. The results from the query were then collected into R and visualized with
ggplot2. For more information on using databases with R, see db.rstudio.com.
library(DBI) library(dplyr) library(ggplot2) con <- dbConnect(odbc::odbc(), "Snowflake") tbl(con, "FLIGHTS") %>% filter(distance > 75) %>% group_by(origin, hour) %>% summarise(delay = mean(dep_delay, na.rm = TRUE)) %>% collect() %>% ggplot(aes(hour, delay, color = origin)) + geom_line()
This release of the drivers includes an updated version of the SQL Server driver that supports environments using exclusively NTLM v2 authentication. Please refer to the documentation for the SQL Server driver in this release for additional details.
The previous release of the drivers introduced a regression for certain MySQL commands such as
USE <database> and
LOAD DATA INFILE. This new release restores that functionality.
We strongly encourage all customers to upgrade to the 1.8.0 release of the RStudio Professional Drivers. This release contains important updates that will help keep your data connections secure and easy to manage. Upgrading drivers literally takes minutes and can help prevent future security and administrative issues. For a full list of changes in this release refer to the release notes.
RStudio offers ODBC database drivers to all current customers using our professional products at no additional charge, so that data scientists and organizations can take full advantage of their data. The drivers are an important part of our effort to promote interoperability between systems and data science languages like R and Python. The RStudio Pro Drivers are commercially licensed and covered by our support program.
Welcome to rstudio.com/blog! We are excited to announce updates to the RStudio blog and can’t wait to share what’s possible with great data science tools.
In an upcoming webinar on November 17th, Solita will showcase how they successfully combined the strengths of RStudio and Tableau at one of Sweden’s largest government agencies.