live wire
▸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 says Cortex Analyst apps keep working, but recommends Cortex Agents; semantic views and verified queries carry overSnowflake Documentation▸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 says Cortex Analyst apps keep working, but recommends Cortex Agents; semantic views and verified queries carry overSnowflake Documentation
nl2sql.ai
guideSNOWFLAKE

Snowflake agents now fail open on missing tools—so clients must surface the warning

Cortex Agents defaults to continuing with accessible tools, but its authorization pre-check does not cover SQL, code execution or custom functions. Production clients need an explicit completeness policy.

Snowflake agent with a warning flag beside a partial answer versus a fully equipped run.
AI-generated illustration
By The News Desk· Oct 18, 2026the quick take — two AI hosts go live when you do

Snowflake’s new inaccessible-tool handling makes one Cortex Agent usable across callers with different grants—but it also creates a new class of successful, incomplete answer.

By default, orchestration.tool_not_accessible is now accept. If a caller cannot access a named Cortex Search, Cortex Analyst, MCP or skill tool, the run continues with the tools that remain available. Snowflake emits a warning rather than rejecting the request. Operators can instead select reject, which returns one HTTP 4XX listing every inaccessible tool in the checked set, or legacy, which stops at the first inaccessible supported tool. (Snowflake documentation)

A completed run is not a complete answer

The practical risk is not privilege bypass: Snowflake says this feature does not grant access the caller lacks. The risk is interpretation. A client that treats HTTP success as evidence that the agent had its full configured capability set can present a partial answer as complete.

The warning surface depends on the invocation path. Streaming REST clients receive a response.warning event before the first model call; non-streaming REST and SNOWFLAKE.CORTEX.DATA_AGENT_RUN place warnings in the final JSON; Snowflake Intelligence displays the warning in the conversation. Snowflake also records it in SNOWFLAKE.LOCAL.AI_OBSERVABILITY_EVENTS. Any custom client that ignores those fields discards the only structured signal that a named capability was unavailable. (Snowflake documentation)

The pre-check has a boundary

Snowflake checks Cortex Search, Cortex Analyst, MCP and skill access at the start of every run. It does not pre-check custom functions and stored procedures, SQL execution, code execution or other tool types. Those failures arrive later as tool results, after which the agent can continue reasoning with whatever it has.

There is another visibility distinction. If the specification names an inaccessible resource, accept mode emits a warning. If Snowflake discovers resources—for example, an MCP configuration using selection: all—unauthorized items are omitted without a warning because the caller did not name them. For Cortex Analyst, the initial check covers access to the semantic model or view, not every referenced table or embedded search service; those failures can surface only when the tool runs. (Snowflake documentation)

Choose a completeness contract

Use reject for workflows where every configured source is required—for example, a financial answer that must reconcile a semantic model with a policy document. Use accept when degraded service is legitimate, but make warnings visible beside the answer and include them in evaluation records.

Then test two failure paths separately: privileges missing at run start, and privileges failing inside SQL, code or custom-tool execution. The former is a configuration gate; the latter is an execution-path test. Without both, a green response code proves only that the agent produced an answer—not that it had the evidence the application promised.

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.