CSV validator to evaluate OMOP compliance

Implementers
1

Hello community,

Is there a multiplatform schema-based validator to check if a CSV dataset is OMOP-compliant? I mean to check beforehand loading to DB, i.e. basically compliance with datatypes and NOT NULL constraint, without FK validation. I know there is Achilles, but AFAIK it checks data that are in DB already.
Googling gave me several projects like CSVlint, csv-validator, etc, but those are not an out-of-box solution for OMOP compliance validation.
I am quite sure this was evoked several times in various contexts, but sorry I cannot find a direct answer.

Thanks

2

Hi, I needed to validate OMOP tables stored as CSV files before DB ingestion, and since I couldn’t find a suitable tool, I built one. It’s written in Perl, but I’d be willing to translate it to other ecosystems if people find it useful. Thanks! manu
OMOP-CSV-Validator