browser

The Browse tab allows you to navigate to and search for a specific data object within the tree.

The Browse pane allows you to navigate to and search for a specific data object within the tree. Click the button on the toolbar to open or close the Browse pane.

No

Name Description

Search

A search field that you can use to find a specific data object.

You can enter a data object name to search for a data object. The viewer performs a case-insensitive substring search. This means it returns any entry that contains the keyword, regardless of capitalization or position in the text.


When you search for dashboard, the following results might return:
  • my-dashboard
  • dashboards-for-work
  • DaSHboard
  • abcDashboardefg
  • DASHBOARDabc

Navigation tree

A navigation tree in which you can search for specific data objects and visualize them in your . The data objects are grouped by node type and have the following structure: system (if applicable) > database > schema > table > column.

  1. The list of data objects contains all systems, databases, schemas, tables and columns that were collected from the data sources by . If available, it also shows the of BI sources, for example Power BI and Looker. In that case, the structure follows the existing structure in the BI source metadata.
  2. The UNUSED branch contains data objects that were detected by , but are not included in any .

View status

The button to show the Status pane.

The Status pane contains the following tab panes:

No

Name Description

Search

A search field that you can use to find a specific data object. Enter the name of a database, schema, table, or column. Searching for a system name is not supported.

When you hover over the search field, a tool tip is displayed, which shows the available search methods:

  • To search for a schema, table, or column with a specific name, enter <nodetype>:<name>, where <nodetype> is the node type, which can be schema, table, or column, and <name> is the respective schema name, table name, or column name. Searching for a specific system or database is not supported.
  • For hierarchical searches, enter two or more combinations of <nodetype>:<name> separated by a space. For example, you can search by using the following combinations: 
    • database:<dbname> schema:<schemaname>
    • database:<dbname> table:<tablename>
    • database:<dbname> schema:<schemaname> table:<tablename> column:<columnname>

    For a detailed list of node types that you can search in your , see the tool tip.

  • You can use abbreviations for search terms, for example s for schema or proc and p for procedure. For details, see the tool tip.
  • You can use % as a wildcard.

All data objects

A link to the complete , showing all data objects in your data sources.

Navigation tree

A navigation tree in which you can search for specific data objects and visualize them in your . The data objects are grouped by node type and have the following structure: system (if applicable) > database > schema > table > column.

The list of data objects contains all systems, databases, schemas, tables and columns that were collected from the data sources by . If available, it also shows the of BI sources, for example Power BI and Looker. In that case, the structure follows the existing structure in the BI source metadata.

The UNUSED branch contains data objects that were detected by , but are not included in any . Search is not supported in the UNUSED section. If you search for a data object in the UNUSED section, the No object found message is shown.

Stats
  • Statistics that show which information is or is not visualized in the . The statistics contain the following data:
    • Tables: the amount of tables that are shown in the .
    • Views: the amount of views that are shown in the .
    • Unused tables: the amount of tables in your data source that are not shown in the .
      This metric is hidden when there are no unused tables.
    • Unused views: the amount of views in your data source that are not shown in the .
      This metric is hidden when there are no unused views.
    • Done: the amount of queries that were processed successfully.
    • Parsing errors: the amount of queries with invalid or unidentified syntax.
    • Analyze errors: the amount of columns that are not linked to a table.