Skip to main content
Pentaho Documentation

Table

Parent article

A fact or dimension table.

Attributes

AttributeData TypeDefinition
nameStringThe name of the table
schemaStringOptional qualifier for table
aliasStringAlias 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

ElementDefinition
SQLThe SQL WHERE clause expression to be appended to any select statement
AggExcludeExclude a candidate aggregate table by name or pattern matching
AggTableA definition of an aggregate table for a base fact table.