Set up an AI provider¶
Ask, Notebook AI and the AI helpers in the saved query editor and App Studio need a language model. Everything else works without one: notebooks, SQL and DQL queries, saved queries, certification, Apps and lineage.
Ask needs a model, even for certified answers
Ask uses the model to understand the question before it looks for a certified saved query. Without a provider, Ask answers Couldn't run this query and says that no AI model is configured.
Pick a provider¶
- Open Settings → AI provider.
- Choose a Provider:
- Anthropic Claude
- OpenAI
- Google Gemini
- Ollama — local
- Custom OpenAI-compatible
- Under How do you want to connect?, choose one:
- Subscription: sign in with your existing Claude or ChatGPT plan, with Sign in with Claude or Sign in with ChatGPT. No API key, and nothing billed per token.
- API key: paste a key, or leave the field empty and set the
environment variable instead (for example
ANTHROPIC_API_KEY). - Local (Ollama): enter the Host, such as
http://localhost:11434.
- Optional: open Advanced enterprise routing to set a Model.
- Click Test, save & activate.
When the test passes, the card at the top reads Active · followed by the provider and model. If the test fails, your previous provider stays active.
Test unsaved values checks the form without saving it.
Run everything on your machine¶
With Ollama — local, questions and data never leave your network:
- Install Ollama and pull a model.
- In Settings → AI provider, choose Ollama — local.
- Set Host to
http://localhost:11434and, under Advanced enterprise routing, the Model name. - Click Test, save & activate.
Search (optional)¶
Search, on the same page, decides whether a question can match a metric by meaning or only by shared words. It reads Search: word-based until you choose otherwise; ZLens never switches by itself, even when Ollama is running.
- Word-based (the default) matches words only. It cannot connect "drinks"
to a
beverage_revenuemetric. - Use local Ollama embeddings (nomic-embed-text) matches by meaning. It runs on this computer and nothing leaves it. Turning it on downloads the model into Ollama if needed and re-embeds the catalog; turning it off goes back to word-based search.
- Technical details has the other models, OpenAI, Test and Re-index catalog, and the embedder in use.
When Ollama serves an embedding model and the project has not chosen one,
zlens notebook says so once in the terminal. A server operator can set
ZLENS_EMBEDDINGS_AUTODETECT=on to adopt a local model automatically.
Where the settings are stored¶
Provider settings are saved in .dql/provider-settings.json in your project.
The starter project's .gitignore keeps it out of git. Keys are never sent
back to the browser.
In Ask¶
The model is shown, not chosen, in Ask: open Answer settings (the sliders icon under the question box) to see Model and pick how much Thinking to use (Auto, Low, Medium or High).
