Stitching is a process that creates relations between database columns that are Column assets in Collibra Data Intelligence Cloud and BI assets representing the same database. Specifically, stitching creates relations between the following assets:
- The assets that are created when you ingest Power BI.
- The assets that are created when you register a data source.
The lineage harvester collects the Power BI source code and sends it to the Collibra Data Lineage service for analysis. The source code is then pushed to Data Catalog where relations are created between Power BI assets in Data Catalog.
At the same time, Collibra analyzes other metadata of data sources that you registered in Data Catalog and creates new relations of the type "Data Element targets / sources Data Element" between Power BI Column assets and Column assets in Data Catalog. It also creates a data flow between data objects, which is visualized in a technical lineage.
To clarify, the Power BI Column is the target of the Column, and the Column is the source of the Power BI Column.
Note When you ingest Power BI, a technical lineage for Power BI Column assets is automatically created.
Stitching: matching the full paths of assets
To stitch assets in Data Catalog to data object collected by the lineage harvester, the Collibra Data Lineage service looks at the full path of the assets in Data Catalog and the full path of Power BI assets. If the full paths match (including for case-sensitivity), the Collibra Data Lineage automatically stitches them.
Tip You can use the Stitching tab page to easily find the full path of assets in Data Catalog and data objects that were collected by the lineage harvester.