We have setup the OMOP CDM schema for a MSSQL database using the following ddl script https://github.com/OHDSI/CommonDataModel/blob/main/inst/ddl/5.4/sql_server/OMOPCDM_sql_server_5.4_ddl.sql
Using a Python script, I have successfully been able import the following csv files into the equivalent placeholder table:
However, trying to import the data from CONCEPT_SYNONYM.csv into the CONCEPT_SYNONYM table is resulting in the following error:
IntegrityError: (‘23000’, “ [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column ‘concept_synonym_name’, table ‘sqldb-gosh-CDM-dev.cdm.CONCEPT_SYNONYM’; column does not allow nulls. INSERT fails. (515) (SQLExecute)”)
I wanted to check if there was a standard approach or an OHDSI tool which is used for importing the vocabulary csv files into the predefined ddl?