Skip to content

AI agent Beta Optional feature

The AI agent takes natural language instructions and autonomously performs data analysis and notebook creation and editing. It can reference the catalog and notebook content while running SQL, checking results, and creating charts.

The model, permissions, and fixed context it uses are managed through an AI profile. For preparing context that's loaded automatically, see Agent context.

If this isn't available under your contract, the legacy AI Assistant feature appears in the same place instead.

INFO

This feature is in beta. The specification might change without notice.

TIP

This is an optional feature. Depending on your contract, it might not be available.

Key features

  • Sending data to the LLM: How data is handled for training purposes, and what information might be sent to the LLM.
  • Enabling it: Enable the AI agent under AI feature settings in workspace settings.
  • Display modes: Side panel / full page.
  • Operation modes: Ask (analysis) / Agent (including creation and editing).
  • Specifying context: Use @ to specify tables, notebooks, saved queries, and more.
  • Agent context: The .agent folder or page, and context from an AI profile.
  • Message queue: Queue, edit, or send a message ahead of turn while a run is in progress.
  • User settings: Auto-approving SQL, auto-loading context, language, and more.
  • AI profile: Manage the model, permissions, and fixed context used.
  • Agent usage: Check session and token usage.
  • Agent connectors: Integrations with external tools (MCP / Direct API).

Sending data to the LLM

Only external LLM services that contractually guarantee your input data won't be used for training are used. If you want to use your own API key, you can configure this under Custom in AI profile.

As the AI agent analyzes and processes data, it might send table data, SQL execution results, and similar information to the LLM service. Check your organization's AI usage policy before using this feature.

Enabling it

Enabling AI features requires Workspace Owner permission.

  1. Open global nav > Workspace settings > AI feature settings.
  2. Turn on AI features overall using the switch at the top of the screen.
  3. Turn on AI Agent under Available AI features.

You can also individually enable the following features on the same screen.

FeatureDescription
AI AgentPerforms data analysis, SQL execution, chart creation, and more from natural language
AI code completionProvides inline SQL completion within a SQL block
AI name suggestionAutomatically suggests names for SQL and charts

Opening it

You can open it in any of the following ways.

  1. Open global nav > AI Agent (full page).
  2. Open the AI Agent icon at the bottom right of the screen (side panel).
  3. Open the side panel with the AI Assistant shortcut (⌘+L / Ctrl+L by default; see Keyboard shortcuts).
  4. Select Mention in the AI agent from a SQL block in a notebook.

If it isn't enabled, AI Agent is disabled is shown, and you can go to the enablement screen from Manage settings.

Display modes

DisplayHow to openDescription
Side panelAI Agent at the bottom right of the screenMakes it easy to use the notebook you're viewing as context
Full pageGlobal nav > AI AgentLets you view chat content in a larger area. You can also get here from Session info > Open in full page mode in the side panel

Operation modes

You can switch between Ask and Agent at the bottom left of the chat input field.

ModeDescription
AskPerforms data analysis, including running SQL. Doesn't edit notebooks or the catalog
AgentPerforms every operation, including creating and editing notebooks. Before editing, an AI edit version is created automatically, so you can revert it

Users without edit permission on the notebook can't select Agent and are limited to Ask.

Specifying context

In the chat input field, use @ to specify what you want the AI agent to reference.

TargetDescription
TableA table in the catalog
NotebookA notebook in the workspace
Saved QueryA saved query
SQL BlockA SQL block in the notebook you currently have open (when candidates exist)
ChartA chart in the notebook you currently have open (when candidates exist)

Chat screen actions

You can perform the following actions from the header.

ActionDescription
New chatStarts a new session
Chat historyLists past sessions and lets you switch between them
Session infoCheck the start time, Total tokens, and more. From the side panel, you can also select Open in full page mode
CloseCloses the side panel (in side panel mode)

In the chat input field, you can change the following settings in addition to the operation mode.

  • The connection to prefer (default is Auto, letting the agent choose)
  • Settings (user settings)
  • AI Profile
  • Language

Message queue

If you send a message while Agent is working... is shown, a waiting list appears above the input field, under the heading Queued messages. Once the current run finishes, queued messages are processed in order starting from the first one. While there's text in the input field, the send button reads Add to queue.

ActionDescription
Send nowInterrupts the run in progress and sends that message immediately
EditEdits a queued message. While editing, use Save / Cancel
DeleteRemoves the message from the queue

User settings

You can change these from Settings > User Preferences in the chat input field.

ItemDescription
Enter to newlineWhen on, Enter inserts a line break and a modifier key+Enter sends. When off, Enter sends
Show SQL detailsShows the SQL body within an Agent message by default
Auto-approve Tool ExecutionRun SQL (per connection; for BigQuery, you can also set Size Limit (BigQuery) in GB), MCP Tool Execution, Connector HTTP Request
Auto-load Agent ContextPersonal / Teamspace / Notebook page (all on by default)

Permissions

The AI agent's actions are carried out within the user's permission scope. The notebooks it can explore and the connections it can use are also limited to what the user can access.

You can configure additional restrictions under Tool permissions in the AI profile (notebooks, connections, connectors, web search / fetch).

If you want to confirm every SQL execution, turn off Run SQL under Auto-approve Tool Execution in user settings.

Checking usage

Under global nav > Workspace settings > Agent usage, you can check session and token usage. Viewing this requires edit permission on the workspace. Usage data is retained for 30 days.

Period and filters

You can choose the period from the following (default is Last 30 days).

PeriodDescription
Last 24 hoursThe most recent 24 hours
Last 7 daysThe most recent 7 days
Last 30 daysThe most recent 30 days
Custom rangeSpecify a start and end date

From Add filter, you can narrow results by the following conditions.

FilterDescription
AccountFilter by user or API key
User typeMember / Guest
ReportFilter sessions that used a report as context
AI profileFilter by the AI profile used
SourceFilter by where the session was launched from
Final statusCompleted / Aborted / Error

The available sources are as follows.

SourceDescription
Full pageSessions launched from global nav > AI Agent
Side panelSessions launched from AI Agent at the bottom right of the screen
APISessions launched through the API
SlackSessions launched from Slack

Overview and Sessions

The screen is split into Overview and Sessions tabs.

Overview shows the following.

DisplayDescription
Sessions / Active users / Turns / Total tokensTotals for the selected period
Daily trendUsage broken down by AI profile. You can switch between Sessions / Tokens
By AI profileToken distribution
Account rankingRanked by token usage

Sessions shows a list with date/time, title, user, AI profile, source, turns, tokens, and final status. Select a row to open the session detail.

Usage under your contract can be checked from workspace settings > Usage.