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?
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
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
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
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
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
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
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
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
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
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
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
BigQuery
Alteryx
Redshift
Streamlit