create_tbl: Create a Vertica Table

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

Description

This function creates a table on Vertica, while dropping any existing table if exists

Usage

create_tbl(conn, table.name, table.vars)

Arguments

conn	A database connection object
table.name	A character string of the schema.table name
table.vars	A chracter string with SQL table column definitions (see example)

Value

A message that informs you of when the table is successfully created

Examples

vertica <- vertica_connect(driver.path)
table.name <- 'dev.test_table'
table.vars <- 'user_id INT, trips INT, gender VARCHAR'
create_tbl(vertica, table.name, table.vars)

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