● Flow Diagram

How a question becomes governed evidence

Follow the solid arrows down the middle — question → AI → governed tools → secure connection → Databricks → data. Everything each step does is logged into the governance & evidence trail on the right. Results flow back up to the user.

Stemline RWE Intelligence — Flow RWE INTELLIGENCE · GOVERNED DATA FLOW Analyst — asks in plain English AI ANALYST · ENTERPRISE-LICENSED Interprets the question · picks a governed tool then formats & explains the result read-only tools · no autonomous framework · no training on data GOVERNED TOOL LAYER cohort_builderdatabricks_query feasibilitystemline_chart browse / schemadictionary read-only SQL guard · SELECT-only · DML/DDL blocked · row-capped SECURE CONNECTION · M2M Service principal OAuth token (rotated) REST over HTTPS SQL Exec · Unity Catalog DATABRICKS SQL WarehouseUnity Catalog GOVERNED DATA · DE-IDENTIFIED FlatironGuardantNorstella GOVERNANCE & EVIDENCE · EVERYTHING LOGGED Review & validation Draft → In review → Validated · human sign-off Provenance log (append-only) SQL · code hash · model · prompt · data version Audit trail auth · tool calls · model calls · admin actions App database (Postgres) chats · cohorts · feasibility · metadata only Every query, cohort, review & chat — stored & restorable. No patient data stored here — only governed metadata. logged results · tables · charts return to the user

Figure 1  |  A plain-English question flows down through the AI analyst, a governed tool layer, a secure machine connection, and into Databricks — and every step is written to the governance & evidence trail on the right. Results return to the user.

request / data flow (top → down) results return to user logged to evidence & audit governed component data / external