Technical background

This topic explains the connection of the data in a database (DB) with the physical layer (equivalent assets in Collibra Data Intelligence Platform) and the logical layer (the packaged model).

Consider the following DB.

When ingesting this DB to Collibra Data Intelligence Platform, the physical layer is created, in addition to an asset for each of the schemas, tables, and columns, as depicted in the following image.

After the physical layer is created in Collibra, the logical layer can be created on top of the physical layer, as follows:

  • Select any column and classify it as any available data classification. Alternatively, you can allow Collibra to classify the column for you.
  • Assign the column to a data attribute.
  • Create additional assets or use the existing assets of different types (Business Process, Data Category, or Data Set) to establish a relation with the columns.

Note Protect supports only those columns that are linked to Table assets. It does not support Database View assets.