Connect physical data to logical data

Important 

In Collibra 2024.05, we launched a new user interface (UI) for Collibra Data Intelligence Platform! You can learn more about this latest UI in the UI overview.

Use the following options to see the documentation in the latest UI or in the previous, classic UI:

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.

Before you begin

You have registered a data source.

You have the required permissions.

Steps

  1. On the main toolbar, 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. Double-click the field in the Data Attribute column.
    The Data Attribute drop-down list with two filters appears.
  6. In the Data Attribute column, click .
    The Data Attribute drop-down list with two filters appears.
  7. Select the Data Attribute asset that you want to link to the Column asset.
    You can filter based on a Data Domain asset or Data Entity asset. If you do, the other drop-down lists are dynamically updated to only show content related to your filter.

    Tip 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.

    Note You can only select one Data Attribute asset. The Data Attribute asset must exist in your Collibra environment.
  8. Click Save. 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.

Tip To delete a Data Attribute asset in the physical data connector overview, double-click the data attribute, remove the value and click Save. If you do so, you also delete the relation between the Column asset and the Data Attribute asset from the respective asset pages.