snowflake_connect: Connect to Snowflake

In cchoe/numerator: R Functions commonly used for Data Scientists at Numerator

Description

This function creates a Snowflake JDBC connection object for querying InfoScout tables directly from R.

Usage

snowflake_connect(
  driver.path = Sys.getenv("SNOWFLAKE_DRIVER_PATH"),
  user = Sys.getenv("SNOWFLAKE_USER"),
  pw = Sys.getenv("SNOWFLAKE_PW"),
  authenticator = "snowflake"
)

Arguments

driver.path	Local path to the Snowflake JDBC driver (.jar)
user	Database username
pw	Database password
authenticator	snowflake authenticator. Defaults to 'snowflake', externalbrowser can be used.

Value

A Snowflake connection object

Examples

driver.path = '/users/me/documents/drivers/snowflake-jdbc-3.6.6.jar'
conn <- snowflake_connect(driver.path)
df <- dbGetQuery(conn, 'SELECT * FROM us_tlog.d_user LIMIT 10;')

cchoe/numerator documentation built on July 25, 2020, 1:52 a.m.