Built-in agents · Analysis
Which BI tools' AI agents hand back to a person?
3 of 15 tools do, according to their public docs, and 9 partly.
Yes: Omni, Hex, Redshift. Partly: Databricks, Snowflake, Sigma, BigQuery, Looker, Tableau, Power BI, Alteryx, MotherDuck.
The question we asked: Does the documentation describe how an agent hands a task back to a person when it cannot proceed?
Grading standard
yes: a built-in agent that cannot finish a task stops and hands it to a person, with the hand-off documented (a notification, a review queue, a pause awaiting a decision). Asking the user a clarifying question during a conversation is partly. Silence is nothing found.
Databricks
Partly
Quoted from Databricks’s docsIf Genie can't answer the question, it might respond by asking a follow-up clarification question.
Source: docs.databricks.com/aws/en/genie-agents/talk-to-genie · checked Oct 26, 2026 · quoted by GPT
Snowflake
Partly
Quoted from Snowflake’s docsReflect and respond: The agent evaluates the results from each tool to decide what to do next, whether that’s asking a clarifying question, calling another tool, or generating a final response.
Source: docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents · checked Oct 26, 2026 · quoted by GPT
Omni
Yes
Quoted from Omni’s docsIf none of these destinations is available, the agent reports that it can't save the dashboard and names who can grant you access.
Source: docs.omni.co/ai/chat · checked Oct 26, 2026 · quoted by GPT
Hex
Yespreview
Quoted from Hex’s docsAlways ask — the agent pauses and shows an approval prompt with the tool name, arguments, and a description of what will happen. Nothing runs until you accept.
Source: learn.hex.tech/docs/api-integrations/external-apps · checked Oct 26, 2026 · quoted by Gemini
Sigma
Partly
Quoted from Sigma’s docsIf your question is vague, Assistant might prompt you to clarify what you're asking for before responding.
Source: help.sigmacomputing.com/docs/ask-natural-language-queries-with-assistant · checked Oct 26, 2026 · quoted by Claude
BigQuery
Partly
Quoted from BigQuery’s docsThe agent might also generate an agent plan automatically and request your approval.
Source: docs.cloud.google.com/gemini/data-agents/data-engineering-agent/agent-overview · checked Oct 26, 2026 · quoted by Claude
Looker
Partly
Quoted from Looker’s docsConversational analytics may ask follow-up questions to clarify any ambiguities in the original query.
Source: cloud.google.com/looker/docs/conversational-analytics-looker-data · checked Oct 26, 2026 · quoted by Claude
Tableau
Partly
Quoted from Tableau’s docsFor example, if you have high cardinality fields, fields with a lot of values, Tableau Agent might ask you to select the values you want.
Source: help.tableau.com/current/online/en-us/web_author_einstein.htm · checked Oct 26, 2026 · quoted by Claude
Power BI
Partly
Quoted from Power BI’s docsThis error message could include a request for clarification, including suggested variants of the user's original data question.
Source: learn.microsoft.com/en-us/power-bi/create-reports/copilot-semantic-models · checked Oct 26, 2026 · quoted by Claude
Metabase
Alteryx
Partly
Quoted from Alteryx’s docsReview the response from Ask Alteryx and confirm next steps if prompted.
Source: help.alteryx.com/aac/en/ask-alteryx/ask-alteryx-in-live-query.html · checked Oct 26, 2026 · quoted by Claude
MotherDuck
Partly
Quoted from MotherDuck’s docs- Changes Dives, not your data. The agent can create and edit Dives when you ask, but it can't change your tables or databases. When you ask for a data change, it writes the SQL for you to run.
Source: motherduck.com/docs/key-tasks/ai-and-motherduck/agent-chat · checked Oct 26, 2026 · quoted by GPT
Mode
Redshift
Yes
Quoted from Redshift’s docsIn this case, it gives you a message that it was not able to generate SQL.
Source: docs.aws.amazon.com/redshift/latest/mgmt/query-editor-v2-generative-ai-example.html · checked Oct 26, 2026 · quoted by GPT
Streamlit