The analyst harness
The analyst harness is Sienna's chat interface for warehouse analysis. It reads the memory graph, runs read-only SQL, returns answers, charts, and tables, and creates or edits dashboard artifacts. Computed requests use the same controlled execution path.
Chat interface
Each thread contains the request, executed work, result, and follow-up context. Completed query turns include a work receipt and a trust record for each returned result.
- Warehouse queriesWrite and run read-only SQL
- Charts and tablesReturn the requested result format
- Contextual follow-upsReuse the thread's question and result context
- Dashboard changesCreate, pin, and edit saved charts
Answer production
Computed requests use five stages. Required definitions resolve before SQL starts. Verification completes before a result is delivered.
Interpretation and definition resolution
Definitions supply the measure, population, time basis, exclusions, and other business choices used by the query. The run selects query mechanics after those choices are resolved.
The run pauses before SQL when a required definition is missing or conflicting. A confirmed choice is stored as a reusable definition record.
WHERE account_segment = 'Enterprise'Query verification
The query runner executes read-only SQL against the warehouse and submits checks selected for the query shape. The verification gate runs query checks and result checks before delivery.
Applicable checks depend on the joins, grouping, measures, and reusable filters in the query. Runner errors remain incomplete verification and cannot be recorded as passes.
SUM(recognized_revenue)
GROUP BY account_regionQuery checks
Join keys preservedpassed
Row count is plausiblepassed
Critical nulls checkedpassed
Date filter exercisedpassed
Result checks
Regions sum to company totalpassed
Company total matches revenue ledgerpassed
Data-quality assessment
Sienna assesses known observations against the question and the SQL it produced. The outcome applies to that request and determines whether the result can be returned, needs a caveat, or must stop.
Regional totals exclude accounts without a region.
Result delivery
Results in chat and dashboards use the same states. Verified results display a check. Limited results display a caveat. Saved charts with blocking findings display an issue until reviewed. New blocking runs stop before delivery.
AnswerNo issue affects this result.
Answer with a caveat42% of older accounts have no region.
UnreliableReview the issue before using this chart.