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
releaseRelease

BigQuery’s transfer MCP is GA—and an analytics agent can now change the pipeline feeding its answers

Google’s managed endpoint exposes creation, update, run and deletion controls, so the safety boundary must cover ingestion operations—not only generated SQL.

Analytics agent can now mutate BigQuery transfer pipelines, not just query results.
AI-generated illustration
By The News Desk· Sep 29, 2026the quick take — two AI hosts go live when you do

Google has made the BigQuery Data Transfer Service MCP server generally available, according to the September 28 BigQuery release note. The managed endpoint does more than let an agent inspect transfer jobs: its published tool catalog includes operations to create, update and delete transfer configurations, start manual runs and delete individual runs. That makes this an operational data-pipeline interface, not merely another read-only context source. (BigQuery release notes; DTS MCP tool catalog)

The important boundary is upstream of SQL

Teams evaluating analytics agents often focus on the SQL the agent generates. Here, the consequential actions can happen earlier. A client connected to Google’s global DTS MCP endpoint can enumerate data sources and transfer configurations, inspect logs and credentials, create or modify schedules, trigger manual loads, and remove configurations or runs. A mistaken or over-broad action could therefore change which data arrives, when it arrives, or whether it remains available before a later natural-language question is translated into SQL. (DTS MCP tool catalog)

Google’s tool contract does include one useful secret-handling guardrail: parameters designated for Secret Manager must be supplied through Secret Manager, and plaintext is explicitly disallowed when creating or updating transfer configurations. The documentation does not, however, describe a universal human-approval step for mutating tools. Approval behavior therefore has to come from the client workflow or the organization’s own controls. (DTS MCP tool catalog)

Do not authenticate it as the operator

Google’s MCP authentication guidance says that when a client uses a person’s identity, the client receives the same resource permissions and its actions are attributed to that person. For production, Google recommends a separate workload or agent identity with minimum permissions; it also points administrators to IAM attributes that can prevent read-write MCP tool use on important resources. (Google Cloud MCP authentication)

That guidance should become a deployment rule. A reporting assistant that only needs transfer freshness and logs should not inherit create, update or delete authority. If an agent genuinely needs to repair a schedule or start a backfill, place those tools behind a distinct identity and an explicit approval path, and record the requested parameters before execution. Google also warns that MCP’s action surface introduces new security risks and offers organization- and project-level policy controls; using the service first requires enabling the relevant product API. (Enable supported products)

The GA milestone removes a product-stage caveat. It does not turn every exposed operation into an appropriate autonomous action. For analytics-agent teams, the practical test is no longer only “Can the agent query BigQuery safely?” It is also “Can it alter the machinery that decides what BigQuery contains?”

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.