Maya AI Assistant
✨ Maya is OneAvant’s AI assistant. In BI, Maya helps you explore data, generate SQL, debug failed queries, and start analyses from the home page.
Maya requires the Maya module on your tenant subscription.
📍 Where Maya appears in BI
| Location | Capability |
|---|---|
| Home | “What should Maya analyze next?” prompt — describe a question and jump into a new query |
| Query editor | Full SQL generator chat panel with schema-aware prompts |
| Databoard AI briefing | Natural-language summary of a databoard’s contents |
➕ Starting from Home
- Open BI → Home.
- Select a data source chip (integration or database).
- Type your question (e.g. “Top 10 products by revenue last month”).
- Submit — BI opens the query editor with Maya already working on SQL.
Starter prompt examples are generated from real table names in your selected source (system tables are filtered out).
⚙️ SQL generator (query editor)
- Chat panel — left side by default; drag the splitter to resize.
- Open editor — collapse chat to full-width SQL canvas, or expand canvas while keeping chat.
- Target source — ensure Maya knows which dataset/schema to use.
- Suggested replies — quick follow-ups after Maya responds.
- Apply SQL — review diffs before replacing your query text.
- Debug execution — send query errors back to Maya for correction.
Hidden automation can retry failed SQL up to a configured limit (auto-debug setting stored in browser).
⚙️ AI briefing (databoards)
On a databoard, enable AI briefing in settings:
- Generates a readable summary of metrics and trends on the board.
- Optional custom prompt to focus the narrative (e.g. “Highlight week-over-week changes only”).
🚫 Scope notes
- Maya consumes AI tokens from your tenant quota.
- Generated SQL should always be reviewed before sharing databoards externally.
- Maya’s schema awareness depends on synced tables being available — connect and sync integrations first.
- If Maya is disabled, Home shows recent queries/databoards without the prompt hero.