Getting the following error while accessing the profile of the patient in atlas.
You need to create the results schema in your CDM database. Documentation is here.
We have a result schema in the database but in that schema cohort table is missing and thats exactly error also reflecting. Actually we have set up this environment using https://github.com/OHDSI/OHDSIonAWS cloud formation template. We have used the sample dataset while doing the set up. I have run the achillies characterization on the data source and in result schema I can see all the achillies table but cohort table is not there in the result schema.
Can you guide me, how I can create that? is cohortMethod something which needs to be used to create cohort table if yes please also guide me how to do that?
@JamesSWiggins : I thought that the OHDSIonAWS builds the results schema based on the DDL provided by WebAPI? I checked the source code, and cohort.sql is included in the result output, so the cohort table should be created. Any ideas?
If you are willing to create the tables yourself, I pointed you the documentation that instructs you how to do so:
Since you do have a WebAPI istance running, you can invoke the endpoint that will output the DDL. Just find the tables that you are missing and execute the statements to set up your results schema.