Table

Overview

A Table is a repository entity that defines a physical table, view-backed table, Data Mart table, or externally filled table in AnalyticsCreator. Tables belong to schemas and provide the column metadata, keys, references, scripts, and OLAP settings used by generated warehouse objects.

Function

Use the Table entity to maintain the table name, schema, table type, compression, historization or persistence relationship, Data Vault relationship, column definitions, calculated columns, dependencies, measures, identity-column settings, and generated table definition.

The editable behavior depends on the table type. Import and external tables allow direct column maintenance. View-based tables expose table metadata but keep source-driven columns read-only. Data Mart tables show OLAP transfer, aggregate, display folder, category, measure, hierarchy, and partition-related options.

When a table is saved, AnalyticsCreator validates required values, checks duplicate table and transformation names in the selected schema, maintains the primary-key index when requested, saves identity-column settings, checks calculated columns for physical tables, and refreshes the interface when a new table is created or renamed.

Access

Tables can be opened from the schema area of the repository navigation tree, from the DWH ribbon tab, from the table list, or by double-clicking a table object in the dataflow diagram.

How to access

Screen overview

The Table detail page contains the following visible fields, tabs, and actions.

ID	Property	Description
1	Table Name	Name of the table in the selected schema. Saving requires a non-empty name, and the same schema cannot already contain a table or transformation with that name.
2	Table Schema	Schema that owns the table. Saving requires a selected schema.
3	Table Type	Controls table behavior. New table records are limited to external table types, while existing records keep their current type unless they are external table variants.
4	Friendly name	Optional business label used in display and generated metadata.
5	Compression Type	Compression setting for generated physical table objects. New records default to compression type 0.
6	Description	Free-text description for the table.
7	Anonymization / check statement	Statement area used with table anonymization and checks. The field supports multiline input and tab characters.
8	Hist of table	Source table for a history table. For history table records, the selectable list is restricted to compatible source tables.
9	Persist of table	Read-only display of the table that a persisted table is based on.
10	Hub of table / Satellite of table / Link of table	Data Vault relationships used to connect table metadata to hub, satellite, or link tables.
11	Has primary key	Creates or maintains a primary-key index from columns with a PK ordinal position.
12	PK clustered	Marks the generated primary-key index as clustered. Clustered primary keys are blocked when the compression setting resolves to clustered columnstore.
13	Primary key name	Primary-key index name. Saving requires a value when primary key generation is enabled, and the name must not duplicate another table primary key.
14	Inheritance controls	Inherit FriendlyName, Inherit Description, Inherit Display Folder, Inherit all references, and Don't inherit PK control whether generated metadata inherits values from upstream objects.
15	OLAP controls	Data Mart table types show OLAP perspective, Export to OLAP, Hidden in OLAP, and OLAP Category fields.
16	Columns	Column grid for physical columns. Visible columns include Add.col, Column name, Data Type, MaxLength, NumPrec, NumScale, Nullable, PKOrdinalPos, Default, FriendlyName, references, OLAP options, Description, Anonymize, inheritance, and Collation.
17	Calculated columns	Calculated column grid. For Data Mart tables, the tab is shown as Tabular OLAP DAX columns and exposes OLAP-specific fields.
18	Scripts	PreScript and PostScript editors with Original and Parsed views. Parsed view runs macro parsing on the entered script.
19	Dependencies	Read-only dependency grid showing column name, referencing columns, and referenced columns.
20	Measures	Data Mart measure grid. New measures use the configured default measure name and display folder. The grid includes measure name, source column, aggregate, hidden flag, tabular and multidimensional statements, parsed output, description, display folder, and format string.
21	Table Definition	Read-only generated table script. The table must be saved before a definition can be generated.
22	Identity column	Optional identity-column definition with Name, Type, Seed, Increment, and PK pos. New identity settings default seed and increment to 1 and type to int.
23	Load field definitions from existing table	For external table types, imports field definitions from an existing database table. Existing columns are replaced after confirmation, and the table definition must be saved first.
24	Create in DWH	Generates and runs the table creation script for a saved non-view table. Unsaved tables and view-based tables cannot be created from this action.
25	Save	Validates the table, saves metadata and child rows, updates the primary-key index and identity column, checks calculated columns for physical tables, and reloads the saved table.
26	Cancel	Returns to the previous page. If there are unsaved changes, AnalyticsCreator asks whether to save or cancel the navigation.

List behavior

• The table list filters by description, table name, schema name, and table type description.
• The list grid shows Table Schema, Table Name, Historization of Table, Persistation of Table, Table Type, Friendly name, and Description.
• When the list is opened from a schema context, it is filtered to that schema.
• Double-clicking a table row opens the selected table in the Table detail page.
• Delete removes the selected table after confirmation.

Table actions

• The Tables node provides List tables and Add externally filled table.
• A selected table provides Locate in diagram, Set diagram filter, Add to diagram filter, Edit table, Delete table, and Add historization.
• Data Vault actions are available from a selected table: Add vault hub, Add vault satellite, and Add vault link.
• Show reference diagram opens the table reference diagram for the selected table.
• Below a table, the navigation tree exposes Columns, Indexes for non-view tables, and References. Data Mart tables can also expose Hierarchies and Partitions.

Related topics