Extract-Transform-Load Framework for Medium Data

---

Documentation for package ‘etl’ version 0.4.1

• DESCRIPTION file.
• User guides, package vignettes and other documentation.
• Package NEWS.

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