Skip to content
SnowflakeDB backend for dplyr
Branch: master
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
R Add region parameter to src_snowflakedb Oct 2, 2017
man-roxygen initial code drop Aug 2, 2015
man Update for compatibility with newer versions of dplyr...release candi… Sep 30, 2017
tests
.gitignore
DESCRIPTION
LICENSE
Makefile
NAMESPACE Update for compatibility with newer versions of dplyr...release candi… Sep 30, 2017
README.md
dplyr-snowflakedb.Rproj

README.md

dplyr.snowflakedb

This R package extends dplyr to add backend support for SnowflakeDB. More details on dplyr can be found in the README page for the project.

R Environment Setup

The dplyr.snowflakedb connectivity to SnowflakeDB uses the RJDBC package, however, the rJava package needs to be installed and working with Java 8 to support the SnowflakeDB JDBC requirements. This may require:

  • installing Java 8
  • running R CMD javareconf so R uses the Java 8 for its JAVA_HOME
  • installing rJava from source so it can be linked against Java 8

If you are using R on Mac OS X, please see this wiki page for the necessary installation steps for rJava.

Once you have rJava installed and verified it is using Java 8, you can install dplyr and dependancies.

install.packages(c("RJDBC", "DBI", "dplyr"))

If you'd like some data to experiment with I'd recommend installing the following packages that most of the dplyr examples and vignettes use.

install.packages(c("nycflights13", "Lahman"))

Installing dplyr.snowflakedb

install.packages("devtools")
devtools::install_github("snowflakedb/dplyr-snowflakedb")

Example SnowflakeDB Connection

library(dplyr)
library(dplyr.snowflakedb)
options(dplyr.jdbc.classpath = "/home/snowman/Downloads/snowflake_jdbc.jar")

my_db <- src_snowflakedb(user = "snowman",
                         password = "letitsnow",
                         account = "acme",
                         opts = list(warehouse = "mywh",
                                     db = "mydb",
                                     schema = "public"))

Issues

Please file any issues or bugs you find using the project's issue page. Please include a minimal reproducible example where possible.

Contributing

If you find an issue and would like to fix it yourself, please do, and submit a pull request so it can be reviewed and merged.

Copyright and License

Copyright 2017 Snowflake Computing, Inc. Licensed under the Apache License, Version 2.0.

You can’t perform that action at this time.