snowflake_connect: Connect to Snowflake

In cchoe/infoscout: R Functions commonly used for Data Scientists at InfoScout

Description

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

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

Usage

snowflake_connect(driver.path, user, pw)

snowflake_connect(driver.path, user, pw)

Arguments

driver.path	Local path to the Snowflake JDBC driver (.jar)
user	Database username
pw	Database password
driver.path	Local path to the Snowflake JDBC driver (.jar)
user	Database username
pw	Database password

Value

A Snowflake connection object

A Snowflake connection object

Examples

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

cchoe/infoscout documentation built on May 20, 2019, 5:42 p.m.