SpecsModelExplore
Overview
Actors
External Systems
Clinical Data Product
Clinical Ingestion
Clinical Data
Analytics & Research
De-identification Pipeline
Analytics Warehouse
LoaderOMOP MapperQuery API
Clinical Apps
Governance & Audit
Analytics Warehouse
Internal structure
Components
Load path
Load
Query
API
Related workflow
SpecsModelExplore
Analytics Warehouse
OverviewGuideAnalytics Warehouse APILinks and Communications

Analytics Warehouse

The Analytics Warehouse is an OMOP CDM analytical store for cohort queries — fed only from de-identified pipeline outputs that passed risk scoring.

Governed SQL only

Researchers use the Query API; ad-hoc direct DB access is not granted.

Internal structure

Could not build diagram for model "example-healthcare".

Components

Loader

Loads de-identified data into the warehouse.

OMOP Mapper

Maps to OMOP common data model.

Query API

Cohort / SQL query API for researchers.

Load path

Map

The OMOP Mapper transforms canonical concepts to OMOP tables.

Load

The Loader bulk-loads approved batches idempotently.

Query

The Query API serves governed SQL to researchers.

API

Cohort and SQL query endpoints are documented on the Overview tab. Every execution is logged to Audit.

Contract

Queries exceeding row or time budget are killed with a suggestion to narrow the cohort.

Related workflow