SpecsModelExploreRequirements
SpecsModelExploreRequirements
Analytics Warehouse
Overview
Guide
Analytics Warehouse API
Twin streams
Links and Communications
IDproduct.analytics.warehouse
DescriptionOMOP-style analytical warehouse.
Keywarehouse
Typemicroservice:service
Statusactive
TeamAnalytics & Research
Owner
analytics@healthcare.example
TechnologiesSpark, PostgreSQL, OMOP
Tags
Table of contents
Guide
Analytics Warehouse
Internal structure
Components
Load path
Load
Query
API
Related workflow
Analytics Warehouse API
Links and Communications
Requirements

Attributes

accessgoverned SQL only
modelOMOP CDM v5.4

Guide

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

Analytics Warehouse API

Links and Communications

1 workflow

Related Workflows(1)

WorkflowModelParticipant idParticipant label
Researcher query

governance.researcher-query

example-healthcareproduct.analytics.warehouseAnalytics warehouse

Requirements