Referential Integrity Indicator with JDBC Connector

Follow

Marisa Macho

• December 23, 2020 13:54

We would like to be able to see if referential integrity is turned off/on for tables. 

 

Business case: A data governance team may be analyzing a table and its field for quality and using the D360 tool they determine that a crucial relationship in the data model is not being enforced in the database. This gives the opportunity for key orphans to exist in either table in the relationship and informs them that they should perform deeper analysis for data cleanup and ongoing monitoring if RI cannot be enforced for some reason. It also informs them that they may want to have a discussion with the custodian on whether RI can be turned on or not.  Finally, data analysts and developers will find higher quality on tables with RI enabled in the database along with the narrative and data quality mechanisms implemented. This will encourage them to use these data stores with confidence.  

0

• Official comment

  

  Suhas Kotha

  • December 29, 2020 15:10

  Hello Marisa,

  We have created Enhancement ticket for this request and our Product Management team is going to review your request. 

  Comment actions Permalink

Please sign in to leave a comment.