Working with Live Models

👤 This documentation is intended for Admins and Data Admins.

Note: Self Service Dashboards is an additional feature. Site administrators can contact their Account Manager for additional information.

In the Model Editor, there are a variety of options for working with tables that are connected from a live data source.

Data can be managed on two levels, the Table level and the Column level.

Any changes made to the schema are reflected in the dashboard or widgets of the live model only after the changes are published.

Table Level

Tables connected to a live model can be managed through the Navigation Pane or through the table itself in the schema.

The table below describes the menu options available from the Navigation Pane and the corresponding icons available in the table’s menu. Either method can be used to modify and manage tables.

To view a 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. On the left side of the column is an icon that indicates what type of data is in the column.

On the right side of the column’s name is an icon that indicates if the column is connected to another table through a relationship. To view more details or disconnect the relationship, hover over the icon.

For each column, hover over its name to display a menu of options to manage columns:

<table style="width:100%">    
<tr>    
<th>Menu Option</th>        
<th>Description</th>     
</tr>    
<tr>    
<td>Description</td>      
<td> Displays related columns together side by side. See <a href="https://documentation.sisense.com/latest/managing-data/working-with-data/create-relations.htm#gsc.tab=0">Creating and Removing a Relationship</a> between Tables for more information. For Amazon Redshift and Microsoft SQL Server only. </td>    
</tr>    
<tr>    
<td>Edit Relationship</td>        
<td> Allows the user to edit a column’s relationship. This option is only available when the column is connected to another table. </td>    
</tr>    
<tr>      
<td>MySQL</td>        
<td> Allows the user to tag a column with metadata that can be used to organize data and search for it later. See <a href="https://documentation.sisense.com/latest/managing-data/working-with-data/tagging.htm">Creating Data Dictionaries</a> for more information. </td>    
</tr>  
</table>