vertica_connect: Connect to Vertica

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

Description

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

Usage

vertica_connect(
  driver.path = Sys.getenv("VERTICA_DRIVER_PATH"),
  user = Sys.getenv("VERTICA_USER"),
  pw = Sys.getenv("VERTICA_PW"),
  host = "prd-dw-elb-vc-Y8UPG9.infoscoutinc.net"
)

Arguments

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

Value

A Vertica connection object

Examples

driver.path = '/users/me/documents/drivers/vertica-jdbc-7.2.3-0.jar'
conn <- vertica_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.