What is Holistics AI
Don't see AI in your workspace? Request access to get it enabled.
Why Holistics AI is structurally different
Most AI analytics tools translate a natural-language question directly into SQL against the raw warehouse schema. The AI has to guess at table joins, canonical date fields, and what business metrics like "revenue" or "active customer" actually mean. The output looks plausible. Often it's silently wrong. Analysts end up verifying every answer.
Holistics AI is built differently. Instead of generating SQL against raw tables, it generates AQL against your governed semantic layer. AQL is a composable query language where metrics are first-class objects: your team's existing definitions of revenue, active customer, retention, and so on. The AI doesn't reinvent business logic; it reuses what you've already defined.
The chain is:
- You define business logic once in AML and AQL: composable, version-controlled, reviewable.
- AI generates AQL (not SQL) from a natural-language question, reusing your governed metric definitions.
- Holistics compiles AQL to SQL deterministically, runs it against your warehouse, and returns the result.
This is why Holistics AI is reliable in places other AI tools aren't: period comparisons, cohort questions, ratios across grains, follow-ups that build on the previous answer. For the full mechanism, including why this approach is more verifiable, governed, and capable than direct text-to-SQL, see Why Holistics AI is reliable.
What it does
Holistics AI helps you work with data faster using natural language. You can ask questions, explore and visualize data, understand charts and dashboards, and build analytics assets, all through conversation. It works in both Reporting and Development environments.
See the full list of capabilities in What you can do with Holistics AI.
How AI stays reliable
Every AI answer is grounded in your semantic layer, not raw database tables. Every query goes through the same permission controls as normal Holistics usage. Generated AQL is compact and human-readable, which makes it easier to verify than the wrangled SQL that direct text-to-SQL systems produce. Read the full architecture in Why Holistics AI is reliable.
Context and customization
The quality of AI answers depends on the context the AI has access to. You can improve results by:
- Enriching your semantic and reporting layers with descriptions, synonyms, and labels
- Defining custom context for your organization's terminology and conventions
- Adding conversation context on the fly
See What AI uses for context for the full picture.
Data security
Your data is protected by design. Holistics AI uses OpenAI with Zero Data Retention enabled: no data sharing and no API call logging. All queries go through your existing permission controls. You can also bring your own LLM for full control. See Data access & policy for details.
Setup
Admins can enable AI, control user access, configure data sharing, and connect custom LLM providers from AI Settings.
Extensibility
Connect Holistics AI to your own tools using the MCP Server, or use AI functions directly in your data warehouse.
Roadmap
See what's coming next in our roadmap.