Assets, domain types, and operating model for the Google Dataplex Universal Catalog integration

The Google Dataplex Universal Catalog integration uses a specific subset of asset types. All of these come out-of -the-box with Collibra.

Asset type Description
Database

Database assets in Collibra represent projects in Google BigQuery.

Schema

A schema is the highest level of physical structure in a Database. It defines the structure of the tables and columns in the database.

Schema assets in Collibra represent datasets in Google BigQuery.

Table

An implementation of data entities in columns and rows, in a given database system. It is the basic structure of a relational database.
Examples: Account_tbl, CUST_ADDR

Table assets in Collibra represent Entries in Dataplex Universal Catalog.

Database View

A Database View is a virtual table based on the result-set of an SQL statement.

Database View assets in Collibra represent Views in Dataplex Universal Catalog.

Column

An atomic unit of data that can be stored in a database table.
Examples: FST_NM, EMPID

Column assets in Collibra represent Aspects for a table Entry in Dataplex Universal Catalog.

Dataplex Universal Catalog operating model