nz_dplyr_to_netezza: dplyr to Netezza table

In thespatiallabatLaurier/nzdggs: Manipulate and Run Analysis on Netezza Using IDEAS Model

Description

Save a dplyr object as netezza table. It can drop table when it already exists.

Usage

nz_dplyr_to_netezza(DSN, dplyr, outputTable, dropIfExist = F)

Arguments

DSN	A DSN object exported from nz_init function
dplyr	a dplyr object
outputTable	name of the output table to store data
dropIfExist	Drop if the outputTable does exist. Default is False. Use it with cautious since it removes data in the existing outputTable permanently

Value

A dplyr object from outputTable

Examples

## Not run: 
DSN <- nz_init("NZSQL_F","ADMIN")
mbp <- nz_table_as_dplyr(DSN,"MPB")
head(mbp)
mbp2 <- nz_dplyr_to_netezza(DSN,mbp,"mbp2")
head(mbp2)

## End(Not run)

thespatiallabatLaurier/nzdggs documentation built on Sept. 7, 2020, 4:33 p.m.