Technical lineage Browse tab pane

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

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 technical lineage, 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 technical lineage, 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 technical lineage. The data objects are grouped by node type and have the following structure: system (if applicable) > database > schema > table > column.

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

Note The UNUSED branch contains data objects that were detected by Collibra Data Lineage, but are not included in any Technical lineage.

Stats
  • Statistics that show which information is or is not visualized in the technical lineage. The statistics contain the following data:
    • Tables: the amount of tables that are shown in the technical lineage.
    • Views: the amount of views that are shown in the technical lineage.
    • Unused tables: the amount of tables in your data source that are not shown in the technical lineage.
      Tip 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 technical lineage.
      Tip 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.