Generate a generic report of non coherent assets compare to the metamodel ?

Hi,

In a metamodel model, we can define min/max values for each attribute and relation an asset type have.

This is in theory, because in real case, we can create asset with missing attribute or relation (count lower of defined in min value). I suppose we can also have asset with number of attributes or relations greater than defined in max values.

Is there a way to produce a generic report (or view or dashboard or …) to list all assets which break what we’ve defined in our metamodel (and not in global assignement, but in specific scope) ?

This will be really helpfull to correct inconsistent data in our datacatalog.

Thanks

Alex

alexandrebargeton

Posted 4 years ago · Edited 1 year ago·Last reply 4 years ago

2 comments

alexandrebargeton

OP4 years ago · Edited

Hi,

Just to let you know that I’ve written an external Java program that calls the Collibra REST API to do all the comparisons (asset vs asset type).

Regards,

Alex

arthurburkhardt

·4 years ago · Edited

You can use validation rules for this.

In a non-interactive workflow (e.g. run on a daily basis)

Query all the assignments to retrieve which attributes and which min/max/other
Create all the validation rules (using the assetApi and attributeApi)
Add all the validation rules to the relevant assignments
Run validation on all assets

Just be aware it might be a very heavy processing (depending on your number of assets), so it will work fine if you restrict to a certain amount of assets, but might get out of hand on millions of assets.

Otherwise, you can do some external processing and iframe a BI tool inside Collibra (e.g. Collibra insights)