Business context · Context and connections

Which BI tools let you mark data off-limits to AI?

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

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

The question we asked: Can you mark a table, field or answer as deprecated or off-limits to the AI?

Prompt your agent about thisClaudeChatGPT
Grading standard

yes: a product setting that removes a table, field or answer from the AI's reach, or marks it deprecated so the AI avoids it, specific to the AI. An instruction in the AI's context telling it not to use something is partly. Ordinary data permissions are AIRESTRICT or GOVBIND, not this.

Databricks

Yes
Quoted from Databricks’s docsHiding a column removes it from the Genie Agents's context, so Genie won't reference it when generating SQL or answering questions.
Source: docs.databricks.com/aws/en/genie-agents/tune-quality · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Snowflake

Partly
Quoted from Snowflake’s docs- Reject all questions about salary data and tell the user this information is not available.
Source: docs.snowflake.com/en/user-guide/views-semantic/custom-instructions · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT partly · Gemini partly

Omni

Yes
Quoted from Omni’s docsAn array of field selectors that determine which fields are provided to the Omni Agent's context window.
Source: docs.omni.co/modeling/topics/parameters/ai-fields · checked Oct 26, 2026 · quoted by Gemini
Claude yes · GPT partly · Gemini yes

Hex

Yes
Quoted from Hex’s docsAdmins and Managers can choose to include, exclude, or endorse data objects for use by Hex's AI agents.
Source: learn.hex.tech/docs/explore-data/data-browser · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT partly · Gemini yes

Sigma

Partlypreview
Quoted from Sigma’s docsNever use this data model for forecasting or predictions.
Source: help.sigmacomputing.com/docs/manage-ai-context-for-data-models · checked Oct 26, 2026 · quoted by Claude
Claude partly (preview) · GPT partly (preview) · Gemini partly (preview)

BigQuery

Partly
Quoted from BigQuery’s docsInstructions. You can instruct a data agent to always filter data to the most recent quarter when asked about "trends," or to group results by "product category" by default.
Source: docs.cloud.google.com/bigquery/docs/conversational-analytics · checked Oct 26, 2026 · quoted by Gemini
Claude partly · GPT partly · Gemini partly

Looker

Partly
Quoted from Looker’s docsExcluded fields: Fields that the data agent should avoid
Source: cloud.google.com/looker/docs/conversational-analytics-looker-data-agents · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT yes · Gemini partly

Tableau

Partly
Quoted from Tableau’s docsHide fields you don’t need and Tableau Agent won’t use these hidden fields.
Source: help.tableau.com/current/online/en-us/web_author_einstein.htm · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT yes · Gemini no

Power BI

Yespreview
Quoted from Power BI’s docsAsk a data question by using a field that isn't in the AI data schema. Copilot shouldn't return an answer.
Claude yes (preview) · GPT yes (preview) · Gemini yes (preview)

Metabase

Yes
Quoted from Metabase’s docsIf you turn on Metabot's Verified or curated content setting, Metabot will only use content that's verified, in an official collection, or published to the Library.
Source: www.metabase.com/docs/latest/data-modeling/semantic-layer/library · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini partly

Alteryx

Yes
Quoted from Alteryx’s docs- Go to the AI Suggested Use Cases with your own data section, and select Enabled from the dropdown.
Claude partly · GPT yes · Gemini yes

MotherDuck

Yes
Quoted from MotherDuck’s docsRetired. Archived Dives stay accessible by URL and ID, but sort last and are hidden from AI agent listings by default.
Source: motherduck.com/docs/key-tasks/dives/dive-statuses · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini partly

Mode

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

Redshift

Yes
Quoted from Redshift’s docsUse this when certain tables are irrelevant or should not be considered in the query generation process.
Source: docs.aws.amazon.com/redshift/latest/mgmt/query-editor-v2-generative-ai.html · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Streamlit

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