docs/Api/nz_dplyr_to_netezza.md

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

nz_dplyr_to_netezza: dplyr to Netezza table

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

Argument |Description ------------- |---------------- 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

DSN <- nz_init("NZSQL","ADMIN")
mbp <- nz_table_as_dplyr(DSN,"MPB")
head(mbp)
mbp2 <- nz_dplyr_to_netezza(DSN,mbp,"mbp2")
head(mbp2)

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