Shared definitions · Building and maintaining assets

Which BI tools let outside agents change definitions?

11 of 15 tools do, according to their public docs.

Yes: Databricks, Snowflake, Omni, Hex, Sigma, Looker, Tableau, Power BI, Metabase, MotherDuck, Mode.

The question we asked: Can an outside coding agent change your shared definitions?

Prompt your agent about thisClaudeChatGPT
Grading standard

The semantic layer is writable from outside the product.

Databricks

Yes
Quoted from Databricks’s docsTo edit a metric view with SQL, use ALTER VIEW with an updated YAML definition.
Source: docs.databricks.com/aws/en/uc-semantics/metric-views/manage · checked Oct 26, 2026 · quoted by GPT
Claude partly · GPT yes · Gemini yes (preview)

Snowflake

Yes
Quoted from Snowflake’s docsBuild semantic views for Cortex Analyst with verified query representations, metrics, and dimensions
Source: docs.snowflake.com/en/user-guide/cortex-code/bundled-skills · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Omni

Yes
Quoted from Omni’s docsCreate and edit model definitions in YAML
Source: docs.omni.co/developers/agent-skills · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Hex

Yes
Quoted from Hex’s docsIngest a semantic project from a zip file.
Source: learn.hex.tech/docs/api-integrations/api/reference · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes (preview) · Gemini yes

Sigma

Yes
Quoted from Sigma’s docsThe sigma-data-models skill provides instructions and reference materials that an AI assistant can use to build and manage Sigma data models from code.
Source: help.sigmacomputing.com/docs/install-skills-for-ai-assistants · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

BigQuery

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

Looker

Yes
Quoted from Looker’s docsOnce your AI agent is connected to the Looker MCP server and your LookML project is open, you can begin using natural language to write and modify code.
Source: cloud.google.com/looker/docs/ai-assisted-development-vscode · checked Oct 26, 2026 · quoted by GPT
Claude yes (preview) · GPT yes · Gemini yes (preview)

Tableau

Yes
Quoted from Tableau’s docsCreate, update, and delete metric definitions
Source: help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref_pulse.htm · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Power BI

Yes
Quoted from Power BI’s docsThe Power BI Authoring MCP server gives an AI agent the tools to create and change Power BI semantic models.
Source: learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp · checked Oct 26, 2026 · quoted by Gemini
Claude yes · GPT yes · Gemini yes

Metabase

Yes
Quoted from Metabase’s docsmb logs in to a Metabase instance and lets you or an AI agent read and write content over the Metabase API: questions, dashboards, collections, transforms, and more.
Source: www.metabase.com/docs/latest/installation-and-operation/metabase-cli · checked Oct 26, 2026 · quoted by Gemini
Claude partly · GPT yes · Gemini yes

Alteryx

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

MotherDuck

Yespreview
Quoted from MotherDuck’s docsRead and write Guides — markdown documents that capture your org's metric definitions, join conventions, and domain context, so agents produce accurate SQL without repetitive prompting
Source: motherduck.com/docs/sql-reference/mcp · checked Oct 26, 2026 · quoted by Claude
Claude yes (preview) · GPT yes (preview) · Gemini yes

Mode

Yes
Quoted from Mode’s docsSimilar to the example for updating query texts, you can also use the Mode API to update a Definition’s text without going into the Definitions editor.
Source: mode.com/developer/api-cookbook/reports/update-definition-texts · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Redshift

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

Streamlit

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