live wire
▸Snowflake’s Cortex Agent quickstart routes metrics and transcripts with prompt rules—but documents no authorization boundarySnowflake▸Oracle Select AI generates SQL/PGQ for property graphs—but errors if one AI profile mixes graphs with tables or viewsOracle▸Domo’s data team standardizes MCP builds with shared scaffolding; beta toolkits inherit user permissionsDomo▸Databricks proposes five outcome signals for agentic BI—and says dashboard counts and license usage miss decision qualityDatabricks▸One vibe-coded database app needed 56+ human test hours and three repair rounds despite AI Studio’s verification claimsMancas & Mancas / arXiv▸BigQuery AI.IF’s default cost mode trains a local model for most rows—and drops row-error thresholdsGoogle Cloud▸AWS’s multi-tenant data-agent pattern gives the broker Lambda no data permissions; Cognito roles carry Lake Formation scopeAWS Big Data Blog▸Amazon OpenSearch’s optimized engine adds nested agent traces, but AWS reserves it for log analytics—not vector searchAWS▸Two interpretation-based provenance semantics cannot express SQL bag difference, new theorem showsKolaitis / arXiv▸Databricks Feature Views reuse one definition for training and live scoring, but online lookup still returns latest available stateDatabricks▸Databricks Genie’s Slack and Teams previews default channel answers to public, even when viewers lack source-data accessDatabricks▸Snowflake’s two-tool GraphRAG agent beat a seven-tool graph setup 70% to 60% on 22 ontology questionsSnowflake Engineering▸Semantix opens an Apache-2.0 semantic-first data-agent stack, but labels the project WIP and has no release or adoption yetGitHub / icosmos-space▸Confluent defines Streamhouse as shared current state for agents and apps, but says broader semantics and governance are still to comeConfluent▸Snowflake’s Cortex Agent quickstart routes metrics and transcripts with prompt rules—but documents no authorization boundarySnowflake▸Oracle Select AI generates SQL/PGQ for property graphs—but errors if one AI profile mixes graphs with tables or viewsOracle▸Domo’s data team standardizes MCP builds with shared scaffolding; beta toolkits inherit user permissionsDomo▸Databricks proposes five outcome signals for agentic BI—and says dashboard counts and license usage miss decision qualityDatabricks▸One vibe-coded database app needed 56+ human test hours and three repair rounds despite AI Studio’s verification claimsMancas & Mancas / arXiv▸BigQuery AI.IF’s default cost mode trains a local model for most rows—and drops row-error thresholdsGoogle Cloud▸AWS’s multi-tenant data-agent pattern gives the broker Lambda no data permissions; Cognito roles carry Lake Formation scopeAWS Big Data Blog▸Amazon OpenSearch’s optimized engine adds nested agent traces, but AWS reserves it for log analytics—not vector searchAWS▸Two interpretation-based provenance semantics cannot express SQL bag difference, new theorem showsKolaitis / arXiv▸Databricks Feature Views reuse one definition for training and live scoring, but online lookup still returns latest available stateDatabricks▸Databricks Genie’s Slack and Teams previews default channel answers to public, even when viewers lack source-data accessDatabricks▸Snowflake’s two-tool GraphRAG agent beat a seven-tool graph setup 70% to 60% on 22 ontology questionsSnowflake Engineering▸Semantix opens an Apache-2.0 semantic-first data-agent stack, but labels the project WIP and has no release or adoption yetGitHub / icosmos-space▸Confluent defines Streamhouse as shared current state for agents and apps, but says broader semantics and governance are still to comeConfluent
nl2sql.ai
analysisAnalysis

Semantic context is becoming portable—but governance still breaks at the handoff

Google can ingest six semantic-model formats, Databricks can publish join relationships, and Snowflake can reuse verified SQL. Together they expose a three-part control problem: provenance, enforcement and review.

By The News Desk· Nov 2, 2026the quick take — two AI hosts go live when you do

Portability is arriving before uniform control

Enterprise analytics stacks are starting to move semantic context across product boundaries instead of rebuilding it inside every assistant. Google says Knowledge Catalog can now ingest semantic models from LookML, BigQuery Graph, dbt MetricFlow, Snowflake Semantic Views, Databricks Metric Views and SAP CSN, while retaining overlapping definitions side by side with their provenance. That is a meaningful interoperability step: an agent can discover business definitions without forcing the organization to translate every model into one new language.

But importing context is not the same as proving that the context is correct. Google’s design makes conflicts visible rather than silently overwriting one definition with another. The operational consequence is that a steward still has to reconcile competing definitions before an agent should treat one as authoritative. Portability moves the disagreement into a shared catalog; it does not resolve it.

Join metadata is guidance, not a constraint

Databricks’ Beta relationships between metric views show the second boundary. A relationship records direction, declared cardinality and a join condition so AI assistants and BI tools do not have to infer joins from column names. Yet Databricks explicitly describes those relationships as metadata only. They do not enforce the declared cardinality, and tools remain free to choose joins for each analysis.

That flexibility is useful, but it creates a validation obligation. A declared MANY TO ONE relationship can guide an assistant while the underlying data violates that assumption. Production teams therefore need a separate test for uniqueness and fan-out risk; catalog metadata alone cannot prevent a duplicated aggregate.

Verified examples also need lifecycle controls

Snowflake’s Cortex Analyst Verified Query Repository adds a third layer: approved question-and-SQL pairs that can influence answers to similar questions. Snowflake exposes which verified query influenced a response, which provides useful runtime provenance. Its schema can also record verified_by and verified_at—but both fields are optional, and Snowflake warns that inaccurate verified queries can reduce performance and accuracy.

The pattern across the three systems is clear. Google transports definitions and preserves provenance. Databricks publishes reusable join intent without enforcement. Snowflake reuses approved SQL and exposes its influence at runtime, but leaves review metadata optional. None of those are defects by themselves; they are different parts of the control plane.

For practitioners, the deployment checklist should match those layers:

  1. Import: preserve source and ownership when semantic definitions cross catalogs.
  2. Validate: test cardinality, freshness and metric assumptions against the underlying data rather than trusting declarations.
  3. Review: give verified queries owners, verification dates and expiry or reapproval rules.
  4. Observe: retain the semantic definition, relationship or verified query that influenced each generated answer.

The emerging semantic layer is becoming portable enough for agents to share context. The harder work is now making provenance, validation and review travel with it.

Filed by The News Desk. Corrections: desk@nl2sql.ai · Our standards →

comments · 0

    Comments are moderated before they appear. Your email is used once to confirm it is you — never shown, never sold. Corrections and questions get an answer from the desk when we have one.