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?
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
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
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
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
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
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
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
Sigma
Tableau
Power BI
Metabase
Alteryx
MotherDuck
Redshift
Streamlit