Risk intelligence · Trust & Safety
Architecture
A conversational layer over order risk, fraud and delivery decisions. Built on Databricks Free Edition.
01
The analyst
Ops · Trust & Safety
- Asks in plain English.
- Writes no SQL.
"Why was ORD-000221 blocked?"
02
Frontend
React · Lovable
- Chat console
- Server fn: ask-genie
- Order drill-in
No credentials in browser
03
Genie Space
Databricks AI/BI
- Natural language → SQL
- Curated instructions
- Domain synonyms
- 8 trusted queries
Conversation API · threaded
04
Unity Catalog
trustgenie.risk
- orders4,961
- risk_decisions4,961
- customers800
Delta · commented · analyzed
05
SQL Warehouse
Serverless
- Executes generated SQL
- Returns rows + result manifest
Service principal · OAuth M2M · secrets held server-side in the connector gateway
USE CATALOG · USE SCHEMA · SELECT · CAN RUN on the Genie Space
Rendered in the console
Answer
Genie's natural-language response, in the analyst's own vocabulary.
Never fabricated — errors surface honestly.
Visualization
Chart form inferred from the actual result shape — stat, bar, or table.
Order IDs become clickable audit records.
SQL receipt
The exact query Genie generated, shown verbatim in a collapsible panel.
Trust through transparency, not assertion.
Remove Genie and the app has no core. Every answer originates from a Genie-generated query against governed Delta tables.