live wire
▸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▸Graph-repair retrieval cut F1 by 0.126 on one suite; a learned router used fewer tokens than always-on retrieval in all sixLin et al. / arXiv▸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▸Graph-repair retrieval cut F1 by 0.126 on one suite; a learned router used fewer tokens than always-on retrieval in all sixLin et al. / arXiv
nl2sql.ai
analysisArchitecture

“Live data” hides three different freshness contracts for analytics agents

Databricks, Confluent and Google all promise current data without traditional batch copies—but they differ on checkpoints, maintained state, replay and who owns correctness.

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

Enterprise vendors increasingly describe agent-accessible data as “live,” “current” or queried “in place.” Those phrases sound interchangeable, but recent first-party material from Databricks, Confluent and Google describes three materially different operating contracts.

The distinction matters because an analytics agent can return a recent-looking answer while still relying on different guarantees about updates, deletes, replay and authorization. Before treating “live” as an architecture, operators need to ask what is actually moving, where state is maintained, and which system is authoritative.

Contract 1: incremental consumption with a checkpoint

Databricks’ OpenSharing implementation guide exposes a shared Delta table and its history to a recipient. A Databricks recipient can use Structured Streaming and a durable checkpoint to process only versions it has not consumed. If it needs a local analytical copy, it materializes that data downstream.

But the change semantics are a deployment choice. Databricks says its ignoreChanges pattern may re-emit rows and does not propagate deletes. Consumers that require inserts, updates and deletes must use Change Data Feed. Non-Spark recipients do not get the same continuous-stream path; they pull changes by version range. Here, “live” means an ordered history is available, while the recipient still owns its checkpoint, target and reconciliation policy.

Contract 2: continuously maintained shared state

Confluent’s Streamhouse proposal puts more responsibility into the middle layer. Change capture and a durable event backbone feed stateful processing, which continuously maintains reusable representations for applications, agents and analytics. Consumers can receive changes, query current state or read materialized tables.

Confluent is explicit that this does not create a perfectly synchronized global “now.” Different implementations still trade latency, consistency, replay, cost and operational complexity. Operational systems remain responsible for authorizing and committing transactions. The contract is therefore not merely access to source history; it is maintained state plus replay and shared context, with source systems retaining transactional authority.

Contract 3: federated query under the user’s identity

Google’s Gemini Enterprise Data Cloud connectors use federated-query mode to query BigQuery, Spanner, Cloud SQL, AlloyDB and Looker without copying or indexing the data into a Gemini data store. Gemini discovers accessible metadata through Knowledge Catalog, generates SQL and executes it under the end user’s credentials, preserving existing row- and column-level controls.

This path avoids maintaining a separate analytical replica inside Gemini. It also shifts the contract toward source availability, query-time permissions and generated-query correctness. Google separates broad exploratory connectors from curated Conversational Analytics agents, which data teams scope to selected data and certified use cases.

Ask for the contract, not the adjective

These designs can coexist. A company might maintain current operational state through streams, publish governed history to partners and let users query selected sources in place. The mistake is assuming that all three uses of “live” promise the same thing.

For every agent-facing source, document four facts: whether reads are federated or materialized; how progress and replay are tracked; how updates and deletes propagate; and which identity authorizes the final read or action. “Live” is a marketing adjective. Those four answers are the production contract.

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.