Table
Overview
A Table is an AnalyticsCreator design object that describes a warehouse table, view, dimension, fact, or related generated structure.
It combines technical column definitions with business metadata, references, indexes, historization or persistence relationships, and semantic settings.
Function
Use table entities to define the physical and semantic structure of warehouse objects.
A table can be created directly, produced by an import or transformation, linked to historization or persisting logic, and exposed to analytical models.
Types
Table roles determine which relationships, editor options, and analytical features are available.
| Type | Use |
|---|---|
| Physical table | Represents a generated or maintained warehouse table. |
| View | Represents a generated or maintained view. |
| Historized or persisted table | Stores historical or persisted results produced by processing logic. |
| Dimension table | Represents an analytical dimension structure. |
| Fact table | Represents an analytical fact structure. |
Attributes
Attributes define the configuration, behavior, and relationships of the table entity.
| Attribute | Applies to | Description |
|---|---|---|
| Name | All table roles | Technical table name. |
| Schema | All table roles | Schema that contains the table. |
| Table type | All table roles | Determines the role and available behavior of the table. |
| Friendly name | Business-facing tables | Business name used in semantic or documentation contexts. |
| Description | All table roles | Documents the purpose of the table. |
| Compression | Physical tables | Compression option used when the table is generated. |
| Columns | All structured tables | Physical and semantic column definitions. |
| Primary key and indexes | Physical tables | Key and index definitions used by the table. |
| References | Related tables | Relationships to other table entities. |
| Analytical metadata | Dimensions and facts | Friendly names, display folders, measures, hierarchies, partitions, and related semantic settings. |
How it is used in AnalyticsCreator
| Use case | Description |
|---|---|
| Define warehouse storage | Describe the columns, keys, indexes, and generation settings of a warehouse table. |
| Receive imported data | Act as the target of an import definition. |
| Store transformation results | Represent a transformation output or persisted result. |
| Support historization | Participate in source-to-history relationships. |
| Provide analytical structures | Serve as a dimension, fact, hierarchy owner, or partition owner. |
Relationships
| Related entity | Relationship |
|---|---|
| Schema | A table belongs to one schema. |
| Column | A table contains physical or calculated columns. |
| Index | A physical table can contain indexes. |
| Table reference | A table can reference or be referenced by another table. |
| Transformation | A table can be an input, output, or persisted result of a transformation. |
| Package | Imports, historizations, persistings, and exports connect package work to tables. |
| Hierarchy | Analytical tables can own hierarchies. |
| Partition | Analytical tables can own OLAP partitions. |
Where to configure
Configure or review this entity from the matching AnalyticsCreator user-interface area.
