pipe_table: complete ETL pipe in a single function

In vh-d/RETL: Various tools for ETL

Description

complete ETL pipe in a single function

pipe_table vectorized

complete ETL pipe

Usage

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 = FALSE
)

pipe_tables(tables, ...)

etl_pipe(
  from,
  to,
  transform = NULL,
  read_args = list(),
  write_args = list(overwrite = TRUE),
  asDT = TRUE,
  lowercase = FALSE
)

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/RETL documentation built on June 28, 2020, 10:33 a.m.