pipe_table: complete ETL pipe in a single function

Description Usage Arguments

Description

complete ETL pipe in a single function

pipe_table vectorized

Usage

1
2
3
4
5
pipe_table(name, from, to, name_target = NULL, transform = NULL,
  from_schema = NULL, to_schema = NULL, read_args = list(),
  write_args = list(overwrite = TRUE), asDT = TRUE, lowercase = TRUE)

pipe_tables(tables, ...)

Arguments

name

name of the table

from

DBI/R environment/file name

to

DBI/R environment/file name

name_target

optional parameter specifying new name of the table at the target

transform

transformation function

from_schema

optional parameter with name of schema at the origin database

to_schema

optional parameter with name of schema at the target database

read_args

list of arguments passed to read/extract function

write_args

list of arguments passed to write/load function

asDT

logical; convert the data.frame to data.table during the etl?

lowercase

logical; lowercase all column names?

tables

vector of table names

...

args passed to 'pipe_table()'


vh-d/ETLtools documentation built on May 18, 2019, 2:36 p.m.