Preview of tables and fields in the data model viewer

In the data model viewer, you can get a preview of any data table in a panel at the bottom of the screen. In the preview, you can quickly inspect the contents of a table or field. You can also add dimensions and measures to the app quickly if you select a field.

Additionally, metadata for the selected table or field are displayed in the preview panel.

You can show and hide the preview panel in two ways:

• Click j in the toolbar.
• Click the Preview header.

Showing a preview of a table

Do the following:

• Click a table header in the data model viewer.

The preview panel is displayed with fields and values of the selected table.

Showing a preview of a field

Do the following:

• Click a table field in the data model viewer.

The preview panel is displayed with the selected field and its values, and metadata for the field. You can also add the field as a master dimension or measure.

• Density is the number of records that have non-NULL values in this field, as compared to the total number of records in the table.
• Subset ratio is the number of distinct values of the field found in this table, as compared to the total number of distinct values of this field in other tables in the data model. This is only relevant for key fields.
• If the field is marked with [Perfect key], every row contains a key value that is unique.

See: Creating a master dimension from the data model viewer

See: Creating a master measure from the data model viewer