Ask and analyze · Analysis

Which BI tools' AI names the fields it used?

5 of 15 tools do, according to their public docs, and 4 partly.

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

The question we asked: Does the answer say which specific tables, columns or metrics it was built from?

Prompt your agent about thisClaudeChatGPT
Grading standard

Named tables, columns or metrics attached to the answer, such as a field list or a citation shown with it. The text of a generated query is credited to the analytical-steps row, not this one, even though it names tables. Naming only the dataset does not count.

Databricks

Yes
Quoted from Databricks’s docsFound relevant data: When applicable, shows the specific tables or data sources Genie identified as relevant to your question.
Source: docs.databricks.com/aws/en/genie-agents/talk-to-genie · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Snowflake

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

Omni

Yes
Quoted from Omni’s docsWhen the Omni Agent generates a query, you can view details about the fields used in the results.
Source: docs.omni.co/ai/chat · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Hex

Partly
Quoted from Hex’s docsPick the 3 to 6 most-used topics and gather about 25 representative threads, reading each with hex thread get --json for its resources array (the exact tables and semantic models it touched) and hex thread messages --json for the conversation, where the agent's replies usually include the SQL it ran.
Source: learn.hex.tech/docs/agent-management/evals · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini yes

Sigma

Partly
Quoted from Sigma’s docsReview the sources used by Assistant throughout your conversation.
Source: help.sigmacomputing.com/docs/ask-natural-language-queries-with-assistant · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

BigQuery

Partly
Quoted from BigQuery’s docsMetadata about the conversation, such as the agent and data sources used.
Source: docs.cloud.google.com/bigquery/docs/create-conversations · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT yes · Gemini partly

Looker

Yes
Quoted from Looker’s docsThis explanation includes the raw field names that were used, the calculations that were done, the filters that were applied, the sort order, and other details.
Source: cloud.google.com/looker/docs/conversational-analytics-looker-data · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Tableau

Yes
Quoted from Tableau’s docsClick Metric Sources to see metrics considered as part of the analysis when the response is generated.
Source: help.tableau.com/current/online/en-us/pulse_ask_discover_qa.htm · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Power BI

Yes
Quoted from Power BI’s docsIf Fabric IQ isn't enabled, expand How Copilot arrived at this to review how Copilot interpreted your question and verify the fields, measures, and filters it selected from the semantic model.
Source: learn.microsoft.com/en-us/power-bi/create-reports/copilot-ask-data-question · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Metabase

Partly
Quoted from Metabase’s docsQueries generated: every SQL or query builder (MBQL) query Metabot wrote during the conversation, with the referenced tables listed underneath.
Source: www.metabase.com/docs/latest/ai/usage-auditing · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

Alteryx

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

MotherDuck

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · 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