live wire
IBM makes watsonx Orchestrate AgentOps, custom LLM judging and Bedrock-agent discovery generally availableIBMSchemaGate 0.1.45 fixes broken Oracle ADB wallet connections and an OCI stack pinned 28 releases behindSchemaGatePDI’s Amazon Quick procurement agent grounds spend answers in vendor, category and contract contextAWS Business Intelligence BlogBigQuery’s ML.METRICS example returns 0.84 accuracy but 0.30 macro-F1 on the same 100-row classification queryGoogle Cloud BigQuery docsSchemaGate 0.1.44 auto-selects sentence embeddings, lifting bundled-schema retrieval from 90/98 to 93/98SchemaGateSchemaGate 0.1.43 adds read-only SQL execution with per-principal table checks—and documents unauthenticated client assertionsSchemaGateDatabox adds reusable AI Analyst Skills with personal/company scope, auto-matching and marketplace installsDataboxFabric previews an AI builder for data-agent instructions, source guidance and example queriesMicrosoft FabricDatabricks trains data-agent retriever to stop early or spend bounded extra search steps, reporting 5.8-second latencyDatabricksThoughtSpot adds SpotterCode coding agent to its Visual Embed PlaygroundThoughtSpotLongMemEval-S audit: 67–73% of restore-fixable 80k-budget errors came from evicted evidence under three policiesarXivSchemaGate 0.1.42 adds dimension-aware retrieval and fixes complex multi-table SQL promptsSchemaGateSnowflake agent toolsets can silently drop inherited tools when callers lack accessSnowflake DocumentationLooker’s VS Code extension reaches GA with MCP-assisted LookML generation, editing and validationGoogle Cloud Looker release docsIBM makes watsonx Orchestrate AgentOps, custom LLM judging and Bedrock-agent discovery generally availableIBMSchemaGate 0.1.45 fixes broken Oracle ADB wallet connections and an OCI stack pinned 28 releases behindSchemaGatePDI’s Amazon Quick procurement agent grounds spend answers in vendor, category and contract contextAWS Business Intelligence BlogBigQuery’s ML.METRICS example returns 0.84 accuracy but 0.30 macro-F1 on the same 100-row classification queryGoogle Cloud BigQuery docsSchemaGate 0.1.44 auto-selects sentence embeddings, lifting bundled-schema retrieval from 90/98 to 93/98SchemaGateSchemaGate 0.1.43 adds read-only SQL execution with per-principal table checks—and documents unauthenticated client assertionsSchemaGateDatabox adds reusable AI Analyst Skills with personal/company scope, auto-matching and marketplace installsDataboxFabric previews an AI builder for data-agent instructions, source guidance and example queriesMicrosoft FabricDatabricks trains data-agent retriever to stop early or spend bounded extra search steps, reporting 5.8-second latencyDatabricksThoughtSpot adds SpotterCode coding agent to its Visual Embed PlaygroundThoughtSpotLongMemEval-S audit: 67–73% of restore-fixable 80k-budget errors came from evicted evidence under three policiesarXivSchemaGate 0.1.42 adds dimension-aware retrieval and fixes complex multi-table SQL promptsSchemaGateSnowflake agent toolsets can silently drop inherited tools when callers lack accessSnowflake DocumentationLooker’s VS Code extension reaches GA with MCP-assisted LookML generation, editing and validationGoogle Cloud Looker release docs
nl2sql.ai
releaseRelease audit

Snowflake makes specialized models cheaper to keep warm—but the code link is cold

Semi-Persistence cuts measured model swap cycles by 5.6×–19.9× and explicitly targets specialized text-to-SQL serving. The launch’s promised open-source directory is not yet on the public main branch.

Chart showing much faster model swaps with Semi-Persistence.
Chart: figures from the story
By The News Desk· Aug 28, 2026the quick take — two AI hosts go live when you do

Snowflake has published a serving technique designed to make many specialized models share expensive GPUs without paying a full cold-start penalty whenever demand shifts. The immediate text-to-SQL relevance is explicit: its launch post uses Arctic Text-to-SQL as the example of a focused model that can deliver strong task quality at lower per-token cost than a frontier API. But practitioners trying to reproduce the launch currently hit an important gap: the public code path Snowflake links does not exist on the ArcticInference repository’s main branch.

Keep weights in CPU memory, not on every GPU

The Snowflake Engineering post describes “Semi-Persistence,” which keeps model weights in pinned CPU memory while allowing GPU copies to be discarded and restored as traffic changes. Snowflake separates the reusable model skeleton from its weights, transfers weight shards over multiple PCIe paths and NVLink, and coordinates instances as asynchronous state machines.

On Snowflake’s internal comparison with vLLM Level 2 sleep mode, the complete sleep-and-wake cycle improved by 5.6× to 19.9× across models ranging from 2B to 397B parameters. Single-GPU swaps fell from 1.2–13.5 seconds to 214–801 milliseconds; multi-GPU swaps fell from 10.5–40.6 seconds to 1.75–7 seconds. Snowflake says those runs used AWS p5en.48xlarge instances with eight H200 GPUs and vLLM 0.18.0.

For teams serving several schema-, customer- or domain-specialized NL2SQL models, that changes the capacity question. The practical promise is not a better SQL generator by itself. It is the ability to keep more specialized weights ready in host memory, reclaim GPU capacity from idle models, and restore the needed model quickly enough that swapping can become a scheduler primitive rather than an outage-sized event.

The artifact does not yet match the announcement

Snowflake says it is open-sourcing both the Semi-Persistence primitives and an experimental orchestrator and dashboard at ArcticInference/semi_persistence. As of this check on August 28, the linked GitHub directory returns a file-not-found page. A recursive inspection of the repository’s current main tree likewise shows no semi_persistence directory.

That does not invalidate the published benchmark, but it prevents an independent reader from running the launch instructions or checking implementation details today. The post also reports results on specific H200 and B300 configurations, so even after the code appears, operators should reproduce the swap cycle on their own topology and include CPU-memory pressure, concurrent request latency and model-quality checks.

The useful takeaway is therefore two-part: Snowflake has made a credible systems case for swapping specialized models instead of pinning each one to a GPU, and the public reproduction path is not ready yet. Treat the latency figures as vendor measurements until the promised artifact lands and can be tested.

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.