Inspect the Data in Physical Tables

You can preview and inspect the data in physical and alias tables that use relational data sources.

Use the table preview to view a sample of a table's data and to gain insight into each column's data such as percentage of valid values, percentage of null values, and percentage of a specific value. The table preview contains two parts:

  • Tiles - Shows a distribution of each column's data, uniqueness of values, minimum and maximum values, the percentage of missing or null values, and the percentage of invalid values. You can use tiles to filter column data in the table preview.

    The tiles area of the table preview displays if you have the Create and Edit Datasets permission.

    The table preview includes tiles only if the table contains 125 or fewer columns. See Filter Preview Data in Physical Tables.


    Description of preview_tiles.png follows
    Description of the illustration preview_tiles.png

  • Table - Shows a simplified sample of the data values for each column. You can use a preview tile to filter the data displayed in the table to identify relationships and dependencies between columns.

  1. On the Home page, click Navigator and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Physical Layer Physical layer icon.
  4. In the database pane, double-click the table to inspect its data.
  5. In the physical table, click the Preview tab.