I’m studying OMOP CDM. I’ve created the tables in a PostgreSQL Database and after that, I’ve downloaded the vocabulary at Athena.
Now I’m trying to import the csv files to database, but I’m having constraint errors. I’ve read in other topic that I need to drop all constraints, insert the vocabulary and then create the constraints.
My question is: every time a change occurs in the Athena database I need to make this process? Can I make incremental updates in OMOP CDM?