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 | Exclude a candidate aggregate table by name or pattern matching |
| AggTable | A definition of an aggregate table for a base fact table. |