Business context · Context and connections
Which BI tools give each team its own AI context?
12 of 15 tools do, according to their public docs, and 2 partly.
Yes: Databricks, Snowflake, Omni, Sigma, BigQuery, Looker, Tableau, Power BI, Alteryx, MotherDuck, Mode, Redshift. Partly: Hex, Metabase.
The question we asked: Can different teams get different business context for the AI, rather than one global set?
Grading standard
Context attached to a workspace, team, audience or model rather than the whole tenant.
Databricks
Yes
Quoted from Databricks’s docsA Genie Agent is a domain-specific natural-language chat interface in Databricks where users ask questions of their data and get back SQL queries, results tables, and visualizations. Data analysts curate each agent with datasets registered to Unity Catalog, example SQL queries, SQL expressions for business semantics, and text instructions tailored to the organization's terminology.
Source: docs.databricks.com/aws/en/genie-agents · checked Oct 26, 2026 · quoted by Gemini
Snowflake
Yes
Quoted from Snowflake’s docsPrefer multiple semantic views when you have distinct business domains that don’t need to be joined, or different user groups that need different views of the data.
Source: docs.snowflake.com/en/user-guide/views-semantic/best-practices-modeling · checked Oct 26, 2026 · quoted by GPT
Omni
Yes
Quoted from Omni’s docsThis allows you to personalize the context for each user.
Source: docs.omni.co/modeling/topics/parameters/ai-context · checked Oct 26, 2026 · quoted by Gemini
Hex
Partlypreview
Quoted from Hex’s docsExpose only the fields relevant for a particular analysis or audience
Source: learn.hex.tech/docs/connect-to-data/semantic-models/semantic-authoring/semantic-authori... · checked Oct 26, 2026 · quoted by Claude
Sigma
Yespreview
Quoted from Sigma’s docsYou can add AI context to a data model to help Sigma Assistant better understand how to use your data model as a data source.
Source: help.sigmacomputing.com/docs/manage-ai-context-for-data-models · checked Oct 26, 2026 · quoted by Gemini
BigQuery
Yes
Quoted from BigQuery’s docsIf your agent requires more than 20 data sources, is used across teams that have different metric definitions, or prioritizes one type of result at the expense of another, consider creating additional agents.
Source: docs.cloud.google.com/bigquery/docs/conversational-analytics · checked Oct 26, 2026 · quoted by Claude
Looker
Yes
Quoted from Looker’s docsAgent specialization: Rather than using the single generic interface of a conversation, you can create specialized agents for different business units, such as a Revenue Agent or an Ops Agent.
Source: cloud.google.com/looker/docs/conversational-analytics-overview · checked Oct 26, 2026 · quoted by Claude
Tableau
Yes
Quoted from Tableau’s docsBusiness preferences apply globally across the entire knowledge graph.
Source: help.tableau.com/current/online/en-us/tableau_knowledge_about.htm · checked Oct 26, 2026 · quoted by Claude
Power BI
Yespreview
Quoted from Power BI’s docsProvide instructions about the semantic model that help Copilot understand your business, terminology, and how to prioritize the data in the model.
Source: learn.microsoft.com/en-us/power-bi/create-reports/copilot-prepare-data-ai-instructions · checked Oct 26, 2026 · quoted by Gemini
Metabase
Partly
Quoted from Metabase’s docsWrite descriptions to provide context, define terms, and explain business logic.
Source: www.metabase.com/docs/latest/ai/settings · checked Oct 26, 2026 · quoted by Gemini
Alteryx
Yes
Quoted from Alteryx’s docsAdd custom instructions to guide the agent's behavior and analysis approach.
Source: help.alteryx.com/aac/en/agent-studio/alteryx-agents.html · checked Oct 26, 2026 · quoted by Claude
MotherDuck
Yespreview
Quoted from MotherDuck’s docsWhen your application connects through a service account, access: "user" means private to that service account.
Source: motherduck.com/docs/key-tasks/guides · checked Oct 26, 2026 · quoted by GPT
Mode
Yes
Quoted from Mode’s docsTo retrieve a list of Dataset field descriptions for a given Dataset, send a GET request including the Dataset token to the Dataset field descriptions resource.
Source: mode.com/developer/api-reference/analytics/dataset-field-descriptions · checked Oct 26, 2026 · quoted by Claude
Redshift
Yes
Quoted from Redshift’s docsA resource specifies the scope or portion of a data asset to which the custom context is applied.
Source: docs.aws.amazon.com/redshift/latest/mgmt/query-editor-v2-generative-ai.html · checked Oct 26, 2026 · quoted by Claude
Streamlit