Materialized View Creator

Source code

Workflow

Description

This tool is a shortcut to create a materialized view and build all indices associated with the view

Inputs

Name	Type	Default	Description
database	File		Path to database connection file, usually database.ini
connection_name	string		The name of the section in the database.ini file
input	File?
depends_on	File?		a special field used to enforce dependencies and execution order

Outputs

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

Steps

Name	Runs	Description
create	create.cwl	Load 2015 data (processed by Yun)
index	index.cwl	Build indices
vacuum	vacuum.cwl	Vacuum the view