db_save_view: Saves a tbl object as a view in Vertica.

In vertica/vertica.dplyr: A dplyr connector for Vertica

Description

If the save is defined to be temporary (non-default behavior), the view will be deleted upon termination of the session.

Usage

db_save_view(table, name, temporary = FALSE)

Arguments

table	The local R-variable name of the tbl_vertica object to be saved as a view in Vertica.
name	The name with which to associate the new view in Vertica.
temporary	(Default: FALSE) TRUE if the saved view is to be a local temporary one. Note that saving locally will reduce available parallelism to the native data loader.

Details

Note that all views (temporary and permanent) are treatable as tbl objects in vertica.dplyr.

Value

A new tbl_vertica reference to the saved view.

Examples

## Not run: 
vertica <- src_vertica("VerticaDSN")
table1 <- tbl(vertica,"some_table")
table1_modified <- filter(table1,foo > 3)
new_view <- db_save_view(table1_modified,name="some_table_filtered")

## End(Not run)

vertica/vertica.dplyr documentation built on May 3, 2019, 6:11 p.m.