Table
Overview
A table on 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.
Context Menu
Right-click a table label on the dataflow diagram to open the table context menu. The available commands let users locate the table in the navigation tree, apply diagram filters, refresh the table, add related objects, delete the table, manage references and locks, assign object groups, export the object definition, manage model membership, and customize the table colors.
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
Navigation tree
DWH -> schema -> Tables -> table
Toolbar
DWH -> Tables
Diagram
Double-click the table label to open it, or right-click the table label to open the context menu.
Add from diagram
Use the diagram canvas Add menu to create an externally filled table.
Screen overview
| ID | Command | Description |
|---|---|---|
| 1 | Locate in tree | Locates the selected table in the Data warehouse tree. |
| 2 | Set filter | Sets the selected table as the current filter for the flow diagram. |
| 3 | Add to filter | Adds the selected table to the current diagram filter. |
| 4 | Refresh | Refreshes the selected table in the flow diagram. |
| 5 | Add | Opens the submenu containing the available options for adding a related object. |
| 6 | Delete | Deletes the selected table. |
| 7 | References | Opens the submenu containing reference-related options for the selected table. |
| 8 | Locks | Opens the submenu containing lock-related options for the selected table. |
| 9 | Object groups | Opens options for managing the object groups associated with the selected table. |
| 10 | Import/Export object definition | Opens the submenu for exporting the selected table definition. |
| 11 | Model | Opens the submenu containing model-related options for the selected table. |
| 12 | Customize colors | Opens the submenu for customizing the display colors of the selected table. |
Sub menus
| ID | Submenu group | Description |
|---|---|---|
| A | Add | Contains the available options for adding an object related to the selected table. |
| B | References | Contains options for viewing or managing references associated with the selected table. |
| C | Locks | Contains lock-related options for the selected table. |
| D | Import/Export object definition | Contains options for exporting the selected table definition. |
| E | Model | Contains options for creating a model or adding the selected table to a model. |
| F | Customize colors | Contains options for customizing the colors used to display the selected table. |
A) Add Submenu
| ID | Command | Description |
|---|---|---|
| 1 | Data source | Opens options for adding a data source. |
| 2 | Transformation | Opens options for adding a transformation object. |
| 3 | Export | Opens options for adding an export object. |
| 4 | Calendar dimension | Opens options for adding a calendar dimension. |
| 5 | Time dimension | Opens options for adding a time dimension. |
| 6 | Snapshot dimension | Opens options for adding a snapshot dimension. |
B) References Submenu
| ID | Command | Description |
|---|---|---|
| 1 | Show reference diagram (active) | Shows active reference diagrams associated with the selected table. |
| 2 | Show reference diagram (inactive) | Shows inactive reference diagrams associated with the selected table. |
| 3 | Show reference diagram (all) | Shows all reference diagrams associated with the selected table. |
| 4 | List references | Lists references associated with the selected table. |
| 5 | Add reference | Adds a reference to the selected table. |
| 6 | Start reference | Starts creating a reference from the selected table. |
C) Locks Submenu
| ID | Command | Description |
|---|---|---|
| 1 | Lock object | Locks the selected table. |
D) Import/Export object definition Submenu
| ID | Command | Description |
|---|---|---|
| 1 | Export to file | Exports the selected table definition to a file. |
| 2 | Export to cloud | Exports the selected table definition to the cloud. |
E) Model Submenu
| ID | Command | Description |
|---|---|---|
| 1 | Create model | Creates a model based on the selected table. |
| 2 | Add to model | Adds the selected table to an existing model. |
F) Customize colors Submenu
| ID | Command | Description |
|---|---|---|
| 1 | Background Color | Changes the background color of the selected table. |
| 2 | Foreground Color | Changes the foreground color of the selected table. |
