Pre-declared parameters

Data Query

Attribute	Type	Description
table	#Table	The #Table to generate the data query for
allColumns	boolean	A flag for whether the query is for all columns or only the columns specified in the table definition
caseStyle	String	The style of casing ('actual', 'lower', 'upper')
encapsulate	boolean	A flag for whether to add encapsulation to names
generateSurrogates	boolean	A flag for whether to generate the query with surrogate key columns
allowDataTransformations	boolean	A flag for whether to generate the query with any data transformations specified
additionalColumns	List	A list of String containing additional values for the Select's column clause
additionalWhereClauses	List	A list of String containing additional values for the Select's where clause
retainWhereClause	boolean	A flag for whether to retain the where clause from a previous generated data query

Attribute	Type	Description
table	#Table	The #Table to generate the dw query for
caseStyle	String	The style of casing ('actual', 'lower', 'upper')
encapsulate	boolean	A flag for whether to add encapsulation to names
ECS_AO	String	The encapsulation character for opening alias
ECS_AC	String	The encapsulation character for closing alias
ECS_SO	String	The encapsulation character for opening schema
ECS_SC	String	The encapsulation character for closing schema
ECS_TO	String	The encapsulation character for opening table
ECS_TC	String	The encapsulation character for closing table
ECS_CO	String	The encapsulation character for opening column
ECS_CC	String	The encapsulation character for closing column
forcedSchema	String	Only when non-null, the generated query will have any schemas as this value
retainWhereClause	boolean	A flag for whether to retain the where clause from a previous generated dw query
copyQueryWhereClause	boolean	A flag for whether to copy the where clause from a previous generated data query

Attribute	Type	Description
table	#Table	One of the #Table to generate DDL for
tables	List	A list of #Table containing the tables to generate DDL for
caseStyle	String	The style of casing ('actual', 'lower', 'upper')
encapsulate	boolean	A flag for whether to add encapsulation to names
targetLocations	List	A list of String containing the target locations to filter on. Can contain 'null' for no target location. The list if empty to signify no filtering of target locations

Attribute	Type	Description
table	#Table	The #Table to generate the ddl view query for
queryStyle	String	The type of query to generate, either a data ('data') query or a data warehouse ('dw') query
encapsulate	boolean	A flag for whether to add encapsulation to names
caseStyle	String	The style of casing ('actual', 'lower', 'upper')
allowDataTransformations	boolean	A flag for whether to generate the query with any data transformations specified
ECS_AO	String	The encapsulation character for opening alias
ECS_AC	String	The encapsulation character for closing alias
ECS_SO	String	The encapsulation character for opening schema
ECS_SC	String	The encapsulation character for closing schema
ECS_TO	String	The encapsulation character for opening table
ECS_TC	String	The encapsulation character for closing table
ECS_CO	String	The encapsulation character for opening column
ECS_CC	String	The encapsulation character for closing column

Attribute	Type	Description
table	#Table	The #Table to generate the denormalized query for
encapsulate	boolean	A flag for whether to add encapsulation to names
caseStyle	String	The style of casing ('actual', 'lower', 'upper')
hasDimDate	boolean	A flag for whether the source contains a table named 'dim_date'
queryColumnNames	Map	A map of column keys to alias names to be used instead of the current column name