# 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.

*Source: https://docs.sisense.com/main/SisenseLinux/using-the-model-editor-ec.htm*

---

Last updated: June 10, 2026

|  |  |
| --- | --- |
| [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) |
| Launch     Grow    Enterprise | Cloud     On-Prem |

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.

![Table options elasticube](https://docs.sisense.com/main/Resources/Images/table-options-elasticube.png)

Below are the menu options available from the Navigation Pane.

![Table options menu](https://docs.sisense.com/main/Resources/Images/table-options-menu.png)

| 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](https://docs.sisense.com/main/SisenseLinux/changing-connectivity-settings-for-data-sources.md). |
| 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](https://docs.sisense.com/main/SisenseLinux/creating-data-dictionaries.md). |
| 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. |
| OIDs | View the connection's OID (object identifier) |
| Relationships | Enables you to select two tables and a column to create a relationship. See [Creating and Removing a Relationship Between Tables](https://docs.sisense.com/main/SisenseLinux/creating-and-removing-a-relationship-between-tables.md). |

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.

![Column options menu](https://docs.sisense.com/main/Resources/Images/column-options-menu.png)

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.

![8 6relatedtablethumb](https://docs.sisense.com/main/Resources/Images/8-6relatedtablethumb03001.png)

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

![Column options](https://docs.sisense.com/main/Resources/Images/column-options.png)

| 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](https://docs.sisense.com/main/SisenseLinux/creating-data-dictionaries.md). |
| Relationships | Displays related columns side by side. See [Creating and Removing a Relationship Between Tables](https://docs.sisense.com/main/SisenseLinux/creating-and-removing-a-relationship-between-tables.md). |
| Edit Relationship | Enables you to edit a column's relationship. This option is only available when the column is connected to another table. |