Using the Model Editor

In the Model Editor, you can work with tables you have connected to from an ElastiCube source on two levels - the table level and the column level.

Table Level

You can manage tables through the Navigation Pane or through the table itself in the schema.

Below are the menu options available from the Navigation Pane.

Navigation Pane Description
Preview Displays a preview of your table's data.
Duplicate Duplicates the table.
Rename Enable you to rename the table.
Delete Deletes the table.
Add Custom Code Enables you to add custom code to the table.
Create as View (/ Create as Table) Enables creating a table as view-only for B2D, so users can read from tables without making entirely new copies of them in the CDW. After creating a table as view, the "Create as View" option changes to "Create as Table" to enable changing the table to a writable copy of the table.
Hide All Columns Hides all columns.
Drop All Columns Drops all columns.
Refresh Schema
Updates the table's columns if there was a change on the data source, without having to add the table again.
Connection Settings Enables you to change the connection settings. See Changing Connection Settings for Data Sources.
Tags & Description Enables you to tag a table with metadata that you can use to organize your data and search for it later. See Creating Data Dictionaries.
Add Custom Column Adds a custom column.
Build Behavior When performing a build, enables you to define if the new data will replace the existing data, or be appended to it, or if it will only include the changes.
Relationships Enables you to select two tables and a column to create a relationship. See Creating and Removing a Relationship Between Tables.

To view your table's metadata, including its name, path, provider, location, and the number of columns it contains, hover over the table in the schema or in the Navigation Pane.

Column Level

Columns that are part of a table are displayed below the table in the Navigation Pane.

To the left of the column name is an icon that indicates the column's data type.

If the column is connected to another table through a relationship, a connection icon appears to the right of the column name. You can hover over the connection icon to view more details or disconnect the relationship.

Click the three-dot menu icon next to any column's name to display a menu with options for managing the column:

Menu Option Description
Edit & Preview Displays a preview of your column's data and enables you to edit it.
Duplicate Duplicates the column.
Rename Enable you to rename the column.
Remove Removes the column.
Hide Hides the column.
Drop Drops the column,
Refresh Custom Col Updates the column if there was a change on the data source, without having to add the table / column again.
Description
Enables you to tag a column with metadata that you can use to organize your data and search for it later. See Creating Data Dictionaries.
Relationships

Displays related columns side by side. See Creating and Removing a Relationship Between Tables.

Edit Relationship

Enables you to edit a column's relationship. This option is only available when the column is connected to another table.