Table

Overview

Table in the dataflow diagram represents a warehouse table that can receive data, provide data to downstream transformations, participate in references, and support historization, Data Vault, and semantic modeling work.

Function

A table object can be managed from the DWH toolbar, from the navigation tree, or directly from its label on the dataflow diagram. The diagram context menu lets users locate the table, focus the diagram around it, edit its definition, delete it when appropriate, create historization, add Data Vault structures, manage references, and open the reference diagram.

The table editor maintains the table name, schema, table type, friendly name, compression type, description, key settings, inheritance settings, identity column settings, columns, calculated columns, scripts, dependencies, measures, and generated table definition. It is also where users can load field definitions from an existing table, create the table in the data warehouse, and save table metadata changes.

Access

Tables are available from the DWH toolbar and from schema branches in the navigation tree. On the dataflow diagram, a table can be opened by double-clicking its label or managed from the table label context menu.

How to access

DWH -> schema -> Tables -> table

Toolbar

DWH -> Tables

Diagram

Table label context menu, table label double-click, or diagram canvas Add -> Externally filled table

Visual element

Table object on the dataflow diagram and the table editor

Screen overview

ID Property Description
1Table objectRepresents a warehouse table on the dataflow diagram.
2Table labelIdentifies the table on the diagram and opens the table editor when double-clicked.
3Locate in treeSelects the same table in the navigation tree.
4Set filterRebuilds the diagram around the selected table.
5Add to filterAdds the table to the active diagram filter.
6Store filterSaves the current diagram filter for reuse.
7Remove filterClears the stored diagram filter and refreshes the diagram.
8Add -> Externally filled tableCreates a table that is maintained outside the regular import flow.
9Add -> HistorizationStarts a historization object from the selected table context.
10Add -> PersistingStarts a persisting object from the selected table context.
11Add -> TransformationStarts a downstream transformation from the selected table context.
12Add -> ExportStarts an export object from the selected table context.
13Data vault hash fieldsAdds or refreshes hash fields for Data Vault modeling.
14Data vault hubCreates a Data Vault hub from the selected table context.
15Data vault satelliteCreates a Data Vault satellite from the selected table context.
16Data vault linkCreates a Data Vault link from the selected table context.
17DuplicateCreates a copy of the selected diagram object when duplication is available.
18DeleteRemoves the selected table object when deletion is allowed.
19Show reference diagramShows active, inactive, or all reference relationships for the selected table.
20List referencesOpens the reference list for relationships connected to the selected table.
21Add referenceBegins defining a new reference relationship from the selected table.
22Object groupsOpens group assignment options for organizing or filtering diagram objects.
23Import object definitionImports a saved definition for the selected object.
24Export object definitionExports the selected object definition for reuse.
25Locate in diagramCenters the dataflow diagram on the selected table from the navigation tree.
26Set diagram filterFilters the dataflow diagram to the selected table from the navigation tree.
27Add to diagram filterAdds the selected table to the current navigation-tree diagram filter.
28Edit tableOpens the table editor from the diagram or navigation tree.
29Delete tableDeletes the selected table definition when deletion is allowed.
30List tablesOpens the searchable table list.
31Search criteriaFilters the table list before selecting or deleting an entry.
32Add externally filled tableCreates a new externally filled table from the DWH toolbar or diagram Add menu.
33Table NameDefines the table name shown in lists, the navigation tree, and the diagram.
34Table SchemaSelects the schema that contains the table.
35Table TypeDefines the table role used by loading, generation, and modeling workflows.
36Friendly nameStores a business-facing label for the table.
37Compression TypeSelects the compression behavior for generated table storage.
38DescriptionStores documentation text for the table.
39Hist of tableLinks the table to the table it historizes.
40Persist of tableLinks the table to the table it persists.
41Hub of tableLinks the table to its Data Vault hub context.
42Satellite of tableLinks the table to its Data Vault satellite context.
43Link of tableLinks the table to its Data Vault link context.
44Has primary keyIndicates whether the table has a primary key.
45PK clusteredSets whether the primary key is clustered.
46Primary key nameStores the primary key name used for table creation.
47OLAP perspectiveAssigns the table to a semantic-model perspective.
48Inherit FriendlyNameAllows the table to inherit a friendly name from related metadata.
49Inherit DescriptionAllows the table to inherit description text from related metadata.
50Inherit Display FolderAllows display-folder metadata to be inherited where available.
51Inherit all referencesCopies reference inheritance settings from the related table context.
52Don't inherit PKPrevents primary-key inheritance when the table needs its own key definition.
53Is in-memory tableMarks the table for in-memory behavior where supported.
54Export to OLAPIncludes the table in semantic-model output.
55Hidden in OLAPControls whether the table is hidden in semantic-model output.
56OLAP CategoryGroups the table for semantic-model organization.
57ColumnsMaintains table columns, data types, nullability, keys, references, and descriptions.
58Calculated columnsMaintains calculated columns, statements, persistence, references, and semantic-model settings.
59ScriptsStores PreScript, Original, Parsed, and PostScript content for table processing.
60DependenciesShows referencing and referenced columns for table dependencies.
61MeasuresMaintains measure definitions, aggregate behavior, visibility, and generated statements for semantic-model output.
62Table DefinitionShows the generated table definition text for review.
63Identity columnDefines optional identity-column name, type, seed, increment, and primary-key position.
64Load field definitions from existing tableImports column definitions from an existing table structure.
65Create in DWHCreates the table in the data warehouse.
66CancelLeaves the editor without saving pending changes.
67SaveSaves table metadata and configuration changes.

Related topics