live wire
▸Snowflake agent evals can pin judge versions; unpinned metrics may roll forward and shift scoresSnowflake▸ThoughtSpot makes Spotter 3 default for new instances; it requires download rights and always shares query data with an LLMThoughtSpot documentation▸MotherDuck adds image classification and object location to prompt_jev(), returning typed SQL outputs with confidence scoresMotherDuck▸BigQuery conversational analytics adds Montréal and Toronto; mixed-region agents still default to globalGoogle Cloud Documentation▸Fabric enables Azure OpenAI Copilot access by default, but OpenAI-subprocessor and cross-region processing/storage switches remain offMicrosoft Learn▸Snowflake Cortex Agents now continue by default when named tools are inaccessible, emitting warnings instead of failing the runSnowflake documentation▸Databricks Genie One can use group memberships to tailor answers, while Unity Catalog remains the access-control boundaryDatabricks documentation▸Fabric data agents can query Power BI models with Read alone; Build and workspace access are unnecessaryMicrosoft Learn▸Fabric data-agent Git configs expose column flags, but selecting a table still includes every columnMicrosoft Learn▸Google Data Agent Kit offers remote Spark kernels, but notebook exports can still move results into local Pandas or ArrowGoogle Cloud Documentation▸Cube says production analytics agents need explicit partial-result states, caller-filtered model search and durable artifactsCube▸Thinking Machines names Bridgewater behind ReViSQL-K2.6, citing 92.97% SC-16 accuracy at 15% of frontier-model costThinking Machines Lab▸AWS says a mismatched data/tool/prompt release cut its Field Sales agent pass rate from 78% to 38% in pre-productionAWS Artificial Intelligence Blog▸NL2SQL Multi-Agent ships evaluation artifacts across BIRD, CSpider, Archer and KDD DataSpace—but no software licenseGitHub▸Snowflake agent evals can pin judge versions; unpinned metrics may roll forward and shift scoresSnowflake▸ThoughtSpot makes Spotter 3 default for new instances; it requires download rights and always shares query data with an LLMThoughtSpot documentation▸MotherDuck adds image classification and object location to prompt_jev(), returning typed SQL outputs with confidence scoresMotherDuck▸BigQuery conversational analytics adds Montréal and Toronto; mixed-region agents still default to globalGoogle Cloud Documentation▸Fabric enables Azure OpenAI Copilot access by default, but OpenAI-subprocessor and cross-region processing/storage switches remain offMicrosoft Learn▸Snowflake Cortex Agents now continue by default when named tools are inaccessible, emitting warnings instead of failing the runSnowflake documentation▸Databricks Genie One can use group memberships to tailor answers, while Unity Catalog remains the access-control boundaryDatabricks documentation▸Fabric data agents can query Power BI models with Read alone; Build and workspace access are unnecessaryMicrosoft Learn▸Fabric data-agent Git configs expose column flags, but selecting a table still includes every columnMicrosoft Learn▸Google Data Agent Kit offers remote Spark kernels, but notebook exports can still move results into local Pandas or ArrowGoogle Cloud Documentation▸Cube says production analytics agents need explicit partial-result states, caller-filtered model search and durable artifactsCube▸Thinking Machines names Bridgewater behind ReViSQL-K2.6, citing 92.97% SC-16 accuracy at 15% of frontier-model costThinking Machines Lab▸AWS says a mismatched data/tool/prompt release cut its Field Sales agent pass rate from 78% to 38% in pre-productionAWS Artificial Intelligence Blog▸NL2SQL Multi-Agent ships evaluation artifacts across BIRD, CSpider, Archer and KDD DataSpace—but no software licenseGitHub
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.