Working with Live Models
  • 18 May 2022
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Working with Live Models

  • Dark
    Light
  • PDF

In the Model Editor, you can work with tables you have connected to from a live data source in several ways. You can manage your data on two levels - the table level and the column level. Any changes you make to your schema are only reflected in the dashboard or widgets of the live model after you publish the changes.

Table Level

You can manage tables connected to a live model through the Navigation Pane or through the table itself in the schema.

8-6liveactionsthumb0300.png

Below are the menu options available from the Navigation Pane, and the corresponding icons available in the table’s menu. Either method allows you to modify and manage your tables.

Navigation PaneTable IconDescription
PreviewDisplays a preview of your table’s data.
Refresh Schema>Updates the table’s columns if there was a change on the data source, without having to add the table again.
Delete>Deletes the table.

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. On the left of the column name is an icon that indicates the column's data type.

8-6relatedtablethumb03001.png

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.

Hover over any column's name to display a menu with options for managing the column:

Menu OptionDescription
Relationships

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

For Amazon Redshift and Microsoft SQL Server only.

Edit Relationship

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

DescriptionAllows you to tag a column with metadata that you can use to organize your data and search for it later. See Creating Data Dictionaries.

Was this article helpful?