Connect physical data to logical data

You can use the Physical Data Connector to easily connect a Column asset to a Data Attribute asset via the relation type Data Attribute represents / represented by Column.

A Column asset represents the lowest level of the physical data layer, while a Data Attribute asset represents the lowest level of the logical data layer.

Tip You can also add a relation of the type Data Attribute represents / represented by Column via a Data Attribute's or Column's asset page.

Prerequisites

Steps

  1. On the main menu, click , then Stewardship.
  2. In the submenu, click Physical Data Connector.
  3. In the drop-down list, filter on a database.
    The table shows all ingested schemas in the database. You can use the asset tree to drill down to the column level of the database.
  4. In the asset tree, find the Column asset that you want to link to a Data Attribute asset.
  5. In the Data Attribute column, click .
    A Data Attribute drop-down list with two filters appears.
  6. Link a Data Attribute asset to the Column asset based on the Data Domain and Data Entity filter.
    1. Optionally, select a Data Domain asset and Data Entity asset that are related to the Data Attribute.
      When you filter on a Data Domain asset or Data Entity asset, the other drop-down lists are dynamically updated to only show content related to your filter.
    2. If you want to use the same filters to find Data Attribute assets for other Column assets in the same table, select the Apply filter to all columns in the same table checkbox.
    3. Select the correct Data Attribute asset in the drop-down list.
      Note You can only select one Data Attribute asset. The Data Attribute asset must exist in your Collibra environment.
    4. Click to accept the Data Attribute asset.
    The Data Attribute asset is now linked to the Column asset via the relation type "Data Attribute represents / represented by Column". This relation is also shown on the asset pages of the Column and Data Attribute assets.
    If there is a Data Domain asset and Data Entity asset that is related to the Data Attribute asset, they are shown in the Context column. If you used the filters in the Data Attribute column, the same assets as your filters are shown in the Context column.

Warning If you click to delete a Data Attribute asset in the physical data connector overview, you also delete the relation between the Column asset and the Data Attribute asset from the respective asset pages.