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
analysisPRODUCTION NL2QUERY

Orca’s query agent made a 900-model schema usable by refusing to send all of it to the LLM

Discovery AI cut input tokens 93% and latency 75% by routing deterministic IDs, retrieving examples, pruning schemas and validating every generated filter.

Token use and latency fell sharply after schema routing and validation.
AI-generated illustration
By The News Desk· Oct 14, 2026the quick take — two AI hosts go live when you do

Orca Security’s first natural-language query prototype did what many enterprise teams try first: it placed the full schema in one large-model prompt. The result was usable enough to validate the idea, but each comparable workload consumed roughly 2 million input tokens, took about 60 seconds and still struggled with queries spanning multiple models. Its production replacement is instructive because the largest gain came from narrowing the problem before generation, not merely choosing a larger model. AWS and Orca Security describe the deployed system; the same first-party text is available in the AWS Machine Learning Blog RSS feed.

Nine gates before a query is accepted

Discovery AI translates plain-English security questions into Orca’s JSON-based Sonar filters. Sonar covers more than 900 cloud and application models, relationships among them and 18 filtering operators. The production pipeline first adds customer context, then sends recognizable identifiers—such as IP addresses, CVEs, ARNs and file hashes—through a deterministic fast path. A guardrail blocks prompt injection, off-topic requests and unsupported inputs before generation begins. AWS/Orca

For questions that need generation, the system retrieves 20 semantically similar, previously validated examples using Titan embeddings and reranks them to five with Cohere Rerank 3.5. A model selector then reduces the 900-plus model universe to the schemas relevant to the request. Only those detailed schemas and their connecting relationships reach the generator, which runs as a tool-using agent. AWS/Orca

The resulting filter must pass static checks and validation against the Sonar API. Failed checks return the offending model, field or operator to the generator for a bounded retry; the system returns an invalid-filter response if it cannot reach a valid result. Orca uses Claude Haiku 4.5 for model selection and generation, Nova 2 Lite for guardrails and validation, Titan for embeddings and Cohere for reranking. AWS/Orca

The practical result—and the evidence gap

Orca reports that the new pipeline lowered input use from about 2 million to 140,000 tokens per comparable workload, a 93% reduction. End-to-end latency fell from about 60 seconds to 15 seconds, while overall query cost dropped 90%. The system has handled thousands of production queries per day since March 2026. AWS/Orca

The post says accuracy improved on complex multi-model questions, but it does not publish an absolute accuracy score, the evaluation-set size or a failure-rate breakdown. Its evaluation harness uses curated production-like slices and an LLM judge for correctness, completeness and semantic equivalence, with domain experts feeding corrections back into the example bank. That supports continuous regression testing, but it does not let outsiders compare Discovery AI with another system. AWS/Orca

The transferable lesson is narrower and stronger: when a structured-query agent faces hundreds of models, context reduction is an architectural stage, not a prompt tweak. Deterministic routing, example retrieval, schema selection and executable validation can reduce the amount the generator must see—and leave it fewer ways to invent a valid-looking but nonexistent field.

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.