As part of the creation of the OMOP CDN database, after running the Achilles RPackage there are more tables need to be created inside the cdm_results schema.
The process of creating those tables are as follows:
make HTTP call to http://<server:port>/WebAPI/ddl/results?dialect=<your_cdm_database_dialect>&schema=<your_results_schema>&vocabSchema=<your_vocab_schema>&tempSchema=<your_temp_schema>&initConceptHierarchy=true
this endpoint will return SQL statements which includes DDLs to generate those table.
see https://github.com/OHDSI/WebAPI/wiki/CDM-Configuration#results-schema-setup for more information.
Those tables should be exported to CSV files and stored inside the public blob storage container and added to the list of tables inside infra/scripts/create_omop_cdm.sh
As part of the creation of the OMOP CDN database, after running the Achilles RPackage there are more tables need to be created inside the
cdm_resultsschema.The process of creating those tables are as follows: make HTTP call to
http://<server:port>/WebAPI/ddl/results?dialect=<your_cdm_database_dialect>&schema=<your_results_schema>&vocabSchema=<your_vocab_schema>&tempSchema=<your_temp_schema>&initConceptHierarchy=truethis endpoint will return SQL statements which includes DDLs to generate those table. see https://github.com/OHDSI/WebAPI/wiki/CDM-Configuration#results-schema-setup for more information.Those tables should be exported to CSV files and stored inside the public blob storage container and added to the list of tables inside infra/scripts/create_omop_cdm.sh