Warehouse logic · Building and maintaining assets

Which BI tools' AI can read your warehouse logic?

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

Yes: Databricks, Snowflake, Omni, Hex, BigQuery. Partly: Looker.

The question we asked: Can the built-in assistant read logic that lives in your warehouse?

Prompt your agent about thisClaudeChatGPT
Grading standard

When your definitions live in dbt or a warehouse semantic view, the assistant uses them.

Databricks

Yes
Quoted from Databricks’s docsA Genie Agent is based on data registered to Unity Catalog, including managed tables, external tables, foreign tables, views, metric views, and materialized views.
Source: docs.databricks.com/aws/en/genie-agents/concepts · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Snowflake

Yes
Quoted from Snowflake’s docsCurrently, Cortex Agents reads the information captured in the semantic view definition and generates the SQL against the physical tables directly.
Source: docs.snowflake.com/en/user-guide/views-semantic/overview · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

Omni

Yes
Quoted from Omni’s docsOmni imports each Snowflake semantic view as a topic, with the semantic view's field definitions, relationships, and AI instructions.
Source: docs.omni.co/connect-data/snowflake-semantic-views · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Hex

Yes
Quoted from Hex’s docsWith Threads, users can ask natural language questions and get AI-powered insights based on semantic models and warehouse tables, all in a conversational interface.
Source: learn.hex.tech/docs/explore-data/threads · checked Oct 26, 2026 · quoted by Gemini
Claude yes · GPT yes (preview) · Gemini yes

Sigma

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

BigQuery

Yes
Quoted from BigQuery’s docsUse knowledge sources such as tables, views, graphs, and UDFs with a data agent.
Source: docs.cloud.google.com/bigquery/docs/conversational-analytics · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Looker

Partlypreview
Quoted from Looker’s docsFor BigQuery and Snowflake connections, the sql_analytic_model_name parameter specifies the name of an existing in-database analytic model (a BigQuery Graph or a semantic view in Snowflake) to use as the basis for a LookML view.
Source: cloud.google.com/looker/docs/reference/param-view-sql-analytic-model-name · checked Oct 26, 2026 · quoted by GPT
Claude partly (preview) · GPT partly (preview) · Gemini yes (preview)

Tableau

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

Power BI

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

Metabase

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

Alteryx

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

MotherDuck

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

Mode

No
Quoted from Mode’s docsWhen you click the generate button, Mode pulls the currently selected warehouse name, column names & data types for all tables explicitly referenced in your SQL, and sends them and your SQL edits to OpenAI for context.
Source: mode.com/help/articles/ai-assist · checked Oct 26, 2026 · quoted by Claude
Claude no · GPT nothing found · Gemini nothing found

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