Chart logic · Building and maintaining assets

Which BI tools let outside agents write chart logic?

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

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

The question we asked: Can an outside coding agent write the calculation behind a specific chart or table in BI content?

Prompt your agent about thisClaudeChatGPT
Grading standard

An outside agent can change the calculation behind a specific chart or table in BI content through the vendor's interface. Styling need not be writable. Replacing a whole file or workbook is partly.

Databricks

Partly
Quoted from Databricks’s docsThat means that when you edit a dashboard file directly, you can upload that file to the original workspace and overwrite the existing file while maintaining the existing sharing settings.
Source: docs.databricks.com/aws/en/dashboards/automate/import-export · checked Oct 26, 2026 · quoted by GPT
Claude partly · GPT partly · Gemini partly

Snowflake

Partly
Quoted from Snowflake’s docsArtifact administration SQL manages existing artifacts; it doesn’t create artifacts or edit their content.
Source: docs.snowflake.com/en/user-guide/snowflake-artifacts · checked Oct 26, 2026 · quoted by Gemini
Claude partly · GPT partly · Gemini partly

Omni

Yes
Quoted from Omni’s docsExisting key, changed content → the tile is updated (the server regenerates its internal identifier).
Source: docs.omni.co/api/documents-v2/create-draft-and-patch-document · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Hex

Yes
Quoted from Hex’s docsUpdate a cell's source and/or data connection.
Source: learn.hex.tech/docs/api-integrations/api/reference · checked Oct 26, 2026 · quoted by GPT
Claude partly · GPT yes · Gemini yes (preview)

Sigma

Partlypreview
Quoted from Sigma’s docsTo update a workbook, you must provide a complete representation of the workbook, even if you are only making minor changes.
Source: help.sigmacomputing.com/docs/manage-workbooks-as-code · checked Oct 26, 2026 · quoted by Claude
Claude partly (preview) · GPT partly (preview) · Gemini partly (preview)

BigQuery

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

Looker

Yes
Quoted from Looker’s docsUpdate the dashboard element with a specific id.
Claude yes · GPT yes · Gemini yes

Tableau

Partly
Quoted from Tableau’s docsPublishes a workbook on the specified site.
Source: help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref_publishing.htm · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

Power BI

Partlypreview
Quoted from Power BI’s docsPBIR file authoring and validation - creates and edits pages, visuals, filters, themes, and formatting in PBIR/PBIP format.
Claude partly (preview) · GPT partly (preview) · 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 Claude
Claude yes · GPT yes · Gemini yes

Alteryx

Partly
Quoted from Alteryx’s docsTo upload a new version to an existing workflow, use the POST {baseURL}/v3/workflows/{workflowId}/versions endpoint.
Claude partly · GPT partly · Gemini partly

MotherDuck

Partly
Quoted from MotherDuck’s docsYou can update the title, description, content (React component code), or any combination.
Source: motherduck.com/docs/sql-reference/mcp/dives/update-dive · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

Mode

Yes
Quoted from Mode’s docsYou can use the API to update a query’s text without accessing the report in the editor.
Source: mode.com/developer/api-cookbook/reports/update-query-texts · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

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