Risk intelligence · Trust & Safety
About TrustGenie
TrustGenie is a conversational risk copilot for e-commerce operations and trust & safety teams. It turns a plain-English question about an order, a region or a fraud trend into a governed warehouse query — and returns the answer, the visualization and the SQL that produced it, in seconds.
The problem
Risk decisions move in minutes. Answers move in days.
01
Every question is a ticket
An analyst asks why an order was blocked; a data engineer writes SQL. The answer lands hours later, long after the decision window closed.
02
Answers without evidence
Dashboards show what happened, never why. Chat tools hallucinate confidently. Neither is safe for a fraud decision that affects real revenue.
03
Governance gets bypassed
Speed usually means exports, spreadsheets and shadow copies — the exact opposite of what a trust & safety function needs.
Our approach
Conversational speed, audit-grade proof.
Genie is the core, not a feature
There is no hand-written query layer to fall back on. Every answer originates from a Genie-generated query against governed Delta tables.
Show the receipt, always
The exact generated SQL, the tables touched, row counts and latency ship with every answer. Trust is demonstrated, never asserted.
Fail honestly
When Genie can't answer, the console says so and surfaces the error detail. No silent fallbacks, no synthetic numbers dressed as results.
Governed by default
A service principal with OAuth M2M holds scoped Unity Catalog grants. No credential ever reaches the browser.
How the solution works
01
Ask
An ops analyst types a plain-English question in the console — or picks one of eight curated benchmark questions.
02
Thread
A server function starts or continues a Genie conversation, so follow-ups like “and what about last week?” keep their context.
03
Resolve
Genie translates the question to SQL against trustgenie.risk and the serverless warehouse executes it. Live status is streamed to the UI.
04
Render
Result shape decides the form: a stat callout, a bar chart or a table. Order IDs become clickable audit records.
05
Verify
The SQL receipt, data sources, confidence signal and latency sit under every answer, one click away.
Technology used
Everything runs on Databricks Free Edition.
Intelligence
- Databricks AI/BI Genie Space
- Genie Conversation API (threaded)
- Curated instructions, synonyms & trusted queries
Data
- Unity Catalog · trustgenie.risk
- Delta tables: orders, risk_decisions, customers
- Serverless SQL Warehouse
Application
- React 19 · TanStack Start server functions
- Tailwind v4 design system
- Service principal OAuth M2M via connector gateway
A proof of concept with production instincts: governed data, threaded conversation, and an answer you can defend line by line.
Built by Brahma Reddy.