Workflow to load Medicaid data from files

Source code

Workflow

Description

This tool is a shortcut to ingest CMS Medicaid raw data

Inputs

Name	Type	Default	Description
registry	File?		A path to the data model file
input	Directory		A path to directory, containing unpacked CMS files. The tool will recursively look for data files according to provided pattern
database	File		Path to database connection file, usually database.ini
connection_name	string		The name of the section in the database.ini file
table	string		the name of the table to be created
domain	string	cms	the name of the domain
incremental	boolean	True
depends_on	File?		a special field used to enforce dependencies and execution order

Outputs

Name	Type	Description
reset_log	File
create_log	File
index_log	File
vacuum_log	File
reset_err	File
create_err	File
index_err	File
vacuum_err	File

Steps

Name	Runs	Description
reset	reset.cwl	Initializes Raw CMS tables
create	load_raw_medicaid.cwl	Run data loader to load files to the database
index	index.cwl	Build indices
vacuum	vacuum.cwl	Vacuum the view