This is a source of a bit of confusion:
There are 3 main schemas that WebAPI references:
The ‘webapi’ schema: This is the schema that WebAPI manages. You can name it anything you want, as it is specified in your settings.xml file. In your case, it looks like you named it ‘ohdsi’. This table contains the catalog of tables that WebAPI needs to support it’s function: job tables, other repository tables, etc. This schema is not associated to any specific CDM instance. It maintains a map, however, to multiple CDMs via the source
and source_daimon
tables.
The ‘cdm’ schema: This is the schema that contains the Common Data Model tables such as DRUG_EXPOSURE, CONCEPT, etc. Sometimes people refer to the subset of tables in the CDM for vocabulary as the ‘vocabulary schema’, but a ‘cdm’ schema contains all vocabulary tables plus the patient-level tables.
The ‘results’ schema: This is a the schema that WebAPI uses to write analyitical results for a CDM. the ‘cdm’ schema and the ‘results’ schema is always co-located in the same server. Ie: it is very common to see operations that performs INSERT INTO results_schema.result_table SELECT ... from cdm_schema.cdm_table
. The results
schema is not automatically configured via WebAPI. Instead, for each CDM you have, you need to create a results schema for it, and then populate it with the tables defined in the DDL script viewable by going to your WebAPI istance: /WebAPI/ddl/results
.
The instructions you are reading have no way of knowing what you named your ‘webapi’ schema. So, the default instructions say ‘insert into webapi.source_daimon’. But you should change the ‘webapi’ schema name in the example to the schema name you made for yourself in your database.