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

table

string

the name of the table to be created

domain

string

medicaid

the name of the domain

incremental

boolean

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

Execute DDL

index

index.cwl

Build indices

vacuum

vacuum.cwl

Vacuum the view