Skip to main content
Pentaho Documentation

Table

A fact or dimension table.

Attributes

Attribute Data type Definition
name String The name of the table
schema String Optional qualifier for table.
alias String Alias to be used with this table when it is used to form queries. If not specified, defaults to the table name, but in any case, must be unique within the schema. (You can use the same table in different hierarchies, but it must have different aliases.)

Constituent elements

Element Definition
SQL The SQL WHERE clause expression to be appended to any select statement
AggExclude  
AggTable