Built-in agents · Analysis

Which BI tools let you save a reusable AI assistant?

8 of 15 tools do, according to their public docs, and 3 partly.

Yes: Databricks, Snowflake, Omni, Sigma, BigQuery, Looker, Tableau, Alteryx. Partly: Hex, Power BI, Metabase.

The question we asked: Can you save a built-in assistant with its own instructions, data and permissions, and let colleagues reuse it?

Prompt your agent about thisClaudeChatGPT
Grading standard

An assistant someone configures once, with its own instructions, data and permissions, that colleagues can then reuse.

Databricks

Yes
Quoted from Databricks’s docsData analysts configure each agent with Unity Catalog, example SQL queries, instructions, and trusted assets; business users query it through the chat UI.
Source: docs.databricks.com/aws/en/genie-agents/set-up · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Snowflake

Yes
Quoted from Snowflake’s docsYou define an agent as a reusable object that bundles its model, tools, and orchestration instructions.
Source: docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Omni

Yes
Quoted from Omni’s docsA skill is a set of instructions you save once and reuse with the Omni Agent.
Source: docs.omni.co/ai/skills · checked Oct 26, 2026 · quoted by Gemini
Claude yes · GPT partly · Gemini yes

Hex

Partlypreview
Quoted from Hex’s docsTasks themselves are single-player: only the user who created a Task can view and edit the configuration of the Task.
Source: learn.hex.tech/docs/explore-data/tasks · checked Oct 26, 2026 · quoted by Claude
Claude partly (preview) · GPT partly (preview) · Gemini partly (preview)

Sigma

Yes
Quoted from Sigma’s docsInstructions and data sources provide the context, while actions and agents configured in your data platform provide the tools for an agent to take action or enrich insights.
Source: help.sigmacomputing.com/docs/sigma-agents · checked Oct 26, 2026 · quoted by Gemini
Claude yes · GPT yes · Gemini yes

BigQuery

Yes
Quoted from BigQuery’s docsData agents consist of one or more knowledge sources, and a set of instructions specific to a use case for processing that data.
Source: docs.cloud.google.com/bigquery/docs/conversational-analytics · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

Looker

Yes
Quoted from Looker’s docsCollaboration and reuse: Explore conversations are typically limited to one user, while data agents can be shared with other members of your organization.
Source: cloud.google.com/looker/docs/conversational-analytics-overview · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Tableau

Yes
Quoted from Tableau’s docsYou can create permission sets or profiles to control which users can access your new Analytics and Visualization agent.
Claude yes · GPT yes · Gemini yes

Power BI

Partlypreview
Quoted from Power BI’s docsApp-scoped Copilot supports verified answers prepared by app authors.
Source: learn.microsoft.com/en-us/power-bi/create-reports/copilot-introduction · checked Oct 26, 2026 · quoted by Claude
Claude partly (preview) · GPT partly (preview) · Gemini yes (preview)

Metabase

Partly
Quoted from Metabase’s docsSystem prompts let you customize instructions for Metabot.
Source: www.metabase.com/docs/latest/ai/system-prompts · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

Alteryx

Yes
Quoted from Alteryx’s docs- Alteryx Agents: Build an agent to answer natural-language questions about your datasets. Select 1 or more datasets, add custom instructions and starter prompts to guide the agent's responses, and preview the agent before you share it. Agents can return trend analysis, root cause analysis, common cause analysis, and outlier detection.
Source: help.alteryx.com/aac/en/release-notes/agent-studio-release-notes.html · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

MotherDuck

No
Quoted from MotherDuck’s docsThis Flight shows how to build your own data-analysis agent and run it on a schedule in MotherDuck.
Source: motherduck.com/docs/cookbook/flight-analysis-agent · checked Oct 26, 2026 · quoted by GPT
Claude nothing found · GPT no · Gemini nothing found

Mode

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found

Redshift

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found

Streamlit

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found