Extract-Transform-Load Framework for Medium Data


[Up] [Top]

Documentation for package ‘etl’ version 0.4.0

Help Pages

create_etl_package Create an ETL package skeleton
dbRunScript Execute an SQL script
dbWipe Wipe out all tables in a database
db_type Return the database type for an ETL or DBI connection
db_type.DBIConnection Return the database type for an ETL or DBI connection
db_type.src_dbi Return the database type for an ETL or DBI connection
etl Initialize an 'etl' object
etl.default Initialize an 'etl' object
etl_cleanup ETL functions for working with medium sized data
etl_cleanup.default ETL functions for working with medium sized data
etl_create ETL functions for working with medium sized data
etl_create.default ETL functions for working with medium sized data
etl_extract ETL functions for working with medium sized data
etl_extract.default ETL functions for working with medium sized data
etl_extract.etl_cities ETL functions for working with medium sized data
etl_extract.etl_mtcars ETL functions for working with medium sized data
etl_init Initialize a database using a defined schema
etl_init.default Initialize a database using a defined schema
etl_load ETL functions for working with medium sized data
etl_load.default ETL functions for working with medium sized data
etl_transform ETL functions for working with medium sized data
etl_transform.default ETL functions for working with medium sized data
etl_transform.etl_cities ETL functions for working with medium sized data
etl_update ETL functions for working with medium sized data
etl_update.default ETL functions for working with medium sized data
extract_date_from_filename Match year and month vectors to filenames
find_schema Initialize a database using a defined schema
is.etl Initialize an 'etl' object
match_files_by_year_months Match year and month vectors to filenames
print.etl Initialize an 'etl' object
smart_download Download only those files that don't already exist
smart_upload Upload a list of files to the DB
src_mysql_cnf Connect to local MySQL Server using ~/.my.cnf
summary.etl Initialize an 'etl' object
valid_year_month Ensure that years and months are within a certain time span