Query Holistics datasets via the Semantic API using AMQL expressions. Use when the user asks to query, explore, or extract data from Holistics datasets; generate SQL from an explore query; publish AMQL assets to production.
Query Holistics datasets programmatically using their Semantic API. The API handles joins, aggregations, relationships, and permissions — you specify dimensions and metrics, and get clean results back.
Reference link for updates:
Every request requires an API key in the X-Holistics-Key header. The user must provide their key (from User Settings in Holistics).
NEVER log, echo, or expose the API key in output. Store it in a variable and pass it directly.
# Store the key (user provides this)
HOLISTICS_API_KEY="<user-provided-key>"
The key is usually stored in .env or .envrc.
Ask the user which region they use if not obvious from context.
| Region | Base URL |
|---|---|
| APAC | https://secure.holistics.io/api/v2 |
| US | https://us.holistics.io/api/v2 |
| EU | https://eu.holistics.io/api/v2 |
| Holistics internal | https://bi.holistics.io/api/v2 |
Default to holistics internal (bi.holistics.io) unless the user specifies otherwise.
For duty support or internal Holistics tasks, always use bi.holistics.io.
Option A: From a Holistics URL