Detect OMOP version

Implementers
1

Hi -

Is there a query I can run to detect OMOP version? Working with an existing database.

Thanks,
Brian

2

Hello @Brian_Fox,

Assuming that CDM_SOURCE table is populated properly:

SELECT cdm_version FROM cdm_source
3

and if this is about the vocabulary version you are using, the link that @rookie_crewkie provided also solves that mystery:

SELECT vocabulary_version from vocabulary where vocabulary_id = ‘None’

4

Hi thanks! Yeah, as luck would have it, it’s not populated. The table is empty.

5

You can just check the presence of fields that are specific to a version. You could look into the change list and pick something from there.