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 Tableau.
- The assets that are created when you register a data source or import assets.
For Collibra Data Lineage to stitch the assets to the data objects, you must prepare the Data Catalog physical data layer to create the database > schema > table > column or system > database > schema > table > column hierarchy. For more information, see Prepare the Data Catalog physical data layer for Tableau stitching.
The lineage harvester harvests the Tableau source code and sends it to the Collibra Data Lineage service. The Collibra Data Lineage also collects the full names of assets ingested in Data Catalog and stitches them to data objects collected from Tableau. After processing the metadata, the Collibra Data Lineage service ingests the Tableau assets and their characteristics in Data Catalog. Tableau assets that are stitched now show a relation of the type "Data Element targets / sources Data Element" to the stitched asset. This relation type is also visualized in a technical lineage.
To clarify, the Tableau Data Attribute is the target of the Column, and the Column is the source of the Tableau Data Attribute
- If the Column asset is from a data source that is not supported by technical lineage, a standard SQL parser is used to try to visualize the column in a technical lineage, but the technical lineage might not be complete.
- When you ingest Tableau metadata, a technical lineage for Tableau Data Attribute assets is automatically created.
Stitching: matching the full paths of assets
To stitch assets in Data Catalog to data objects 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 Tableau assets. If the full paths match (including for case-sensitivity), the Collibra Data Lineage service automatically stitches them.
Note Ensure that you correctly prepare the Data Catalog physical data layer.
The Technical lineage Stitching tab page shows the full paths of assets in Data Catalog and data objects collected from Tableau. To fix stitching issues, you can look up the full paths and make sure they match, including for case-sensitivity.