snowflake_connect: Connect to Snowflake

Description Usage Arguments Value Examples

View source: R/db_connect.R

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

1
2
3
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

1
2
3
4
5
6
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.