39 Messages
Data Quality Integration - Columns not linked
The Collibra Data Quality integration only builds relationships to Tables - ‘Data Quality Rule governs Table’, even though the column is listed in the DQ Rule path. This means you cannot view DQ metrics at the Column level.
As a result - I have had to build the below manual process for my client:
- Export Rule data from DGC
- Paste into Excel
- Run Power Query to convert relationships to Columns
- Import s/s to DGC
** Tag Tables and Columns with ‘DQ’ Tag
** The final step is done so that I can create a view /diagram filter which shows all Columns in a DB which have a DQ score (see screenshot)
*Please fix this - the data ingested from Collibra DQ should be related to the Column/not table
Community_Alex
683 Messages
•
15.3K Points
2 years ago
@graham.pearman FYI, I moved this and your other DQ post from today to our DQ-specific forum.
0
0
bineeshbabu
35 Messages
2 years ago
Hello @graham.pearman,
CDQ integration do bring the column lineage as well . You need to make sure while creating the rule you select the columns in CDQ. For now you can only select one column here
Once above step is done , you need to go to Data Quality Rule assignment in DGC and below relation " governs Data Element"
This will bring the Column relation to Data Quality Rules as shown below
1
0