The goal of flaky is to provide a dplyr backend and various helpers for using Snowflake with R. You may know about Snowflake’s similar package dplyr.snowflakedb, but that requires rJava, a notriously difficult package to use. Flaky is meant to be use with Snowflake’s ODBC drivers which work well within the Rstudio environment, once you get them installed.
Currently, flaky is only available through GitHub with:
# install.packages("remotes")
remotes::install_github("ndiquattro/flaky")library(dplyr)
library(flaky)
con <- flaky_connect("snowflake_dsn")
con %>%
tbl(dbplyr::in_schema("schema", "table")) %>%
filter(coolness > 10, str_detect(rpackages, "flak")) %>%
collect()