copy_local_tbl: Upload local .csv to a Vertica table

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

Description

This function loads CSV-formatted data into a Vertica table, using COPY statements

Usage

copy_local_tbl(conn, table.name, file.path)

Arguments

conn	A database connection object
table.name	A character string of the schema.table name
file.path	A chracter string of the local file path (see example)

Value

A message that informs you of when the copy is completed

Examples

vertica <- vertica_connect(driver.path)
table.name <- 'dev.test_table'
file.path <- '/Users/johndoe/Desktop/test_data.csv'
copy_local_tbl(vertica, table.name, file.path)

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