After the synchronization, assets become available in Collibra. Fabric synchronization relies on UUIDs.
Warning Do not move the assets to another domain. Doing so may lead to errors during future synchronizations.
Note If a temporary communication issue results in a partial synchronization, the status of the assets that were not synchronized becomes Missing from source. If the assets are identified in the source system during the next fully successful synchronization, the previous statuses are restored.
By default, the assets are shown in a plain list, but you can enable a multi-path hierarchy to show it in a tree structure.
Edge naming conventions for assets created during the Fabric integration
The assets created when integrating Fabric receive a unique full name (fully qualifying name) based on the following naming convention:
| Asset type | Naming convention | Example |
|---|---|---|
| Microsoft Tenant | tenantName | Collibra, Inc |
| Fabric Capacity | tenantName>capacityName | Collibra, Inc>colfabriccapacity1 |
| Fabric Workspace | tenantName>capacityName>workspaceName | Collibra, Inc>colfabriccapacity1>ColEngWorkspace |
| Fabric Warehouse | tenantName>capacityName>workspaceName>warehouseName | Collibra, Inc>colfabriccapacity1>ColEngWorkspace>ColEngWarehouse |
| Fabric Lakehouse | tenantName>capacityName>workspaceName>lakehouseName | Collibra, Inc>colfabriccapacity1>ColEngWorkspace>ColEngLakehouse |
| File | tenantName>capacityName>workspaceName>lakehouseName>filename | Collibra, Inc>colfabriccapacity1>ColEngWorkspace>integrations_lakehouse_no_schemas>Files/cities.csv |
| Database | tenantName>capacityName>workspaceName>databaseName | Collibra, Inc>colfabriccapacity1>ColEngWorkspace>SalesDatabase |
| Schema | tenantName>capacityName>workspaceName>databaseName>schemaName | Collibra, Inc>colfabriccapacity1>ColEngWorkspace>SalesDatabase>OrdersSchema |
| Table | tenantName>capacityName>workspaceName>databaseName>schemaName>tabelName | Collibra, Inc>colfabriccapacity1>ColEngWorkspace>SalesDatabase>OrdersSchema>QuantityTable |
| Column |
tenantName>capacityName>workspaceName>databaseName>schemaName>tabelName>columnName(column) |
Collibra, Inc>colfabriccapacity1>ColEngWorkspace>SalesDatabase>OrdersSchema>QuantityTable>Item(column) |
Integrated assets
You can enable a multi-path hierarchy to show the assets in a tree structure. For the best results, use the following relations in the multi-path hierarchy:
- Technology Asset groups Technology Asset
- Storage Container contains Storage Container
- Storage Container contains Storage Element
- Technology Asset has Schema
- Schema contains Table
- Table contains Column
The following image shows the resulting hierarchical table.
Synchronized metadata
This table shows the metadata for each Fabric asset type if you selected the Fabric integration. If you do not see any of the listed synchronized metadata, you can add characteristics to the layout on the asset type page.
Some of the column metadata listed below is only available when using the Catalog JDBC ingestion and depends on the driver used.
| Asset type | Synchronized metadata | Public ID |
|---|---|---|
| Microsoft Tenant | ||
| Fabric Capacity | Description from source system | DescriptionFromSourceSystem |
| Technology Asset groups / is grouped by Technology Asset | TechnologyAssetGroupsTechnologyAsset | |
| Fabric Workspace | Description from source system | DescriptionFromSourceSystem |
| Technology Asset groups / is grouped by Technology Asset | TechnologyAssetGroupsTechnologyAsset | |
| Fabric Warehouse | Description from source system | DescriptionFromSourceSystem |
| Technology Asset groups / is grouped by Technology Asset | TechnologyAssetGroupsTechnologyAsset | |
| Fabric Lakehouse | Description from source system | DescriptionFromSourceSystem |
| Storage Container contains / is part of Storage Container | FileContainerContainsFileContainer | |
| File | URL | Url |
| Document creation date | DocumentCreationDate | |
| Document modification date | DocumentModificationDate | |
| Storage Container contains/ contained in File | FileContainerContainsFile | |
| Database | Data Source Type | DataSourceType |
| Schema | Description from source system | DescriptionFromSourceSystem |
| Table | Description from source system | DescriptionFromSourceSystem |
|
Schema contains / is part of Table |
SchemaContainsTable | |
| Column |
Technical Data Type Tip
If you selected or Ingest parent and nested columns in the Columns ingestion mode field in the configuration, you can view the structure of the data for columns with a structured technical data type, such as Array or Struct. To do this, click the hyperlink in the Technical Data Type field in the At a glance sidebar of the Column asset. If the At a glance sidebar is hidden, click |
TechnicalDataType |
|
Column Position |
ColumnPosition | |
|
Is Nullable |
IsNullable | |
|
Column is part of / contains Table |
ColumnIsPartOfTable | |
| Description from source system | DescriptionFromSourceSystem | |
| Char Octet Length | CharOctetLength | |
| Is Auto Incremented | IsAutoIncremented | |
| Size | Size | |
| Number Of Fractional Digits | NumberOfFractionalDigits | |
| Is Primary Key | IsPrimaryKey | |
| Primary Key Name | PrimaryKeyName |
. In other locations, such as in Table assets, click the