DEV Community

Cover image for All Data and AI Weekly #252 - 27 July 2026
Timothy Spann
Timothy Spann

Posted on

All Data and AI Weekly #252 - 27 July 2026

#ai #snowflake #agenticai #apacheiceberg

All Data and AI Weekly #252 - 27 July 2026

( AI, Data, Agentic AI, Cortex Code, NiFi, Iceberg, Polaris, Streamlit, Python, Java, SQL, MCP, LLM, RAG, Cortex AI, AIFN, Search, Unstructured Data )

image

Tim's Corner: MCP Goes Stateless, CoCo Desktop GA, Cortex Sense, and the Biggest Protocol Revision in History

Welcome to issue 252 of All Data and AI Weekly! This is a landmark week. The Model Context Protocol 2026-07-28 specification finalizes tomorrow - the largest revision since MCP launched, making the protocol stateless at its core. No more sticky sessions, no more shared session stores - any MCP request can land on any server instance. Meanwhile, CoCo Desktop went GA (July 21), followed immediately by v1.20.0 with better prompt caching and token efficiency. Snowflake shipped SHOW CORTEX BASE MODELS (GA), SQL environment variables for dbt Projects, and multi-Dynamic Table refresh in a single ALTER. The Cortex Sense blog dropped - showing how runtime context lifts agent accuracy from 47% to 83%. The Snowflake Cortex AI Complete Developer Guide 2026 went live on the Builders Blog. Plus the Snowflake AI Pulse monthly webinar aired this week. In ecosystem news: Apache NiFi 2.10.0, Cisco open-sourced their AI-BOM scanner, and the community published a comprehensive Ontology-on-Snowflake series. Let's dig in!

Tim's Content

Air Quality Monitoring Systems - Full SNACK-AI Build

Two complete end-to-end IoT air quality monitoring systems built entirely with Cortex Code - outdoor (AirNow + HazeCam) and indoor (Pimoroni Enviro Urban sensors). Real-time Snowpipe Streaming V2 ingest, Cortex Agents with Semantic Views, Streamlit dashboards, React apps, and Slack alerting.

Blog: Air Quality Deja Vu 2026

Video: Air Quality Monitoring with SNACK-AI and Cortex Code

GitHub (External Air Quality): SNACKAI-CoCo-AirQuality

GitHub (Internal Enviro Monitoring): SNACKAI-CoCo-EnviroUrban

Upcoming Events

Featured: MCP 2026-07-28 - The Protocol Goes Stateless

The Model Context Protocol 2026-07-28 specification finalizes July 28 - the largest revision since launch. The headline: MCP is now stateless at the protocol layer. The initialize handshake is gone. Session IDs are gone. Any request can land on any server instance behind a plain round-robin load balancer. Plus: MCP Apps (server-rendered UIs), Tasks as a formal extension, Enterprise-Managed Authorization promoted to stable, full JSON Schema 2020-12 for tools, W3C Trace Context propagation, and caching with ttlMs. Roots, Sampling, and Logging are deprecated.

Release Candidate Blog: The 2026-07-28 MCP Specification Release Candidate

TechCrunch: AI's Most Important Protocol Is Getting a Little Bit Easier to Use

The Register: Model Context Protocol Prepares to Break With Its Stateful Past

InfoQ: AI Model Context Protocol Adds Centralised Auth for Enterprise

AAIF Deep Dive: MCP 2026-07-28: From Local Tool to Distributed Protocol

Featured: CoCo Desktop Goes GA + v1.20.0

Cortex Code Desktop is now Generally Available (July 21) - the full AI coding agent on your local machine with deep Snowflake awareness. One day later, v1.20.0 shipped with refreshed update cards, improved prompt caching, and better token efficiency making sessions quicker and more cost-efficient.

CoCo Desktop GA: CoCo Desktop - General Availability

CoCo Desktop v1.20.0: CoCo Desktop v1.20.0 Release Notes

Featured: Cortex Sense for Enterprise AI Agents

Cortex Sense (private preview mid-July 2026) is Snowflake's runtime context enrichment layer that lifts AI agent accuracy from 47% to 83% by automatically grounding agents in metadata, query history, semantic views, and business definitions. When evals expose a gap, Cortex Sense grounds itself rather than guesses.

Snowflake Blog: Cortex Sense for Enterprise AI Agents

Cortex AI & Agents

SHOW CORTEX BASE MODELS (GA - July 23)

New command to list all Cortex Base Models available in your account - including lifecycle status, regional availability, legacy date, and end-of-life date. Essential for model governance and planning.

Read more: SHOW CORTEX BASE MODELS GA

Snowflake Cortex AI - Complete Developer Guide 2026

Sandip Pani on the Builders Blog publishes the definitive developer guide covering the full Cortex AI suite: AI_COMPLETE, AI_SENTIMENT, AI_EMBED, AI_REDACT, AI_TRANSCRIBE, Cortex Search, Cortex Analyst, Document AI, Cortex Guard, Cortex Code, and Cortex Agents.

Read more: Snowflake Cortex AI - Complete Developer Guide 2026

Ontology-Grounded Reasoning with Cortex Agents

Snowflake Engineering blog on using knowledge graphs and ontologies to ground Cortex Agents - comparing baseline semantic-view agents with ontology-aware approaches including GraphRAG and targeted terminology mappings. Results show improved accuracy and reliability.

Read more: Ontology-Grounded Reasoning with Cortex Agents

Ontology on Snowflake - Full Series (Builders Blog)

Tianxia Jia publishes the complete Ontology on Snowflake series - from architecture to deployment with a Cortex Code Skill. Covers physical storage, ontology metadata, abstract views, semantic models, and a Cortex Agent orchestration layer.

Read more: Ontology on Snowflake: From Architecture to Deployment

Snowflake AI Pulse - July 2026

Monthly walkthrough of the latest Cortex AI features: CoCo, CoWork, Cortex Agents, AI Functions, and real-time ML updates.

Watch: Snowflake AI Pulse - July 2026

Snowflake Platform Updates

Refresh Multiple Dynamic Tables in One ALTER (July 22)

You can now refresh multiple dynamic tables in a single ALTER DYNAMIC TABLE ... REFRESH statement. Snowflake merges upstream dependencies into one pipeline and refreshes all at a single data timestamp. Shared upstreams refresh exactly once.

Read more: Refresh Multiple Dynamic Tables

SQL Environment Variables & Private Git Packages for dbt Projects (July 23)

dbt Projects on Snowflake now support SQL environment variables and private Git package repositories - enabling multi-environment configurations and secure dependency management directly within Snowflake-managed dbt.

Read more: SQL Environment Variable and Private Git Package Support

AI_TRANSCRIBE Now Supports AAC Audio (July 15)

AI_TRANSCRIBE now supports AAC (Advanced Audio Coding) input - both as standalone audio files and as audio tracks inside supported video files.

Read more: AI_TRANSCRIBE AAC Support

SnowSQL v1.5.1 (July 17)

SnowSQL updated to v1.5.1 with upgraded snowflake-connector-python to 4.7.1.

Read more: SnowSQL 2026 Release Notes

Data Ecosystem & Open Standards

Apache NiFi 2.10.0 Released

Apache NiFi 2.10.0 shipped June 23 - the latest in the 2.x line with Git-based Flow Registry Clients replacing the deprecated NiFi Registry. The UI now shows leading/trailing whitespace in properties and penalized queue status.

Read more: Apache NiFi Downloads

Release Notes: Apache NiFi Release Notes

The Easy Button for Context-Rich AI Agents

How Snowflake Intelligence and Cortex Knowledge Extensions help enterprises unlock insights from internal data and third-party expertise through a unified agent experience.

Read more: The Easy Button for Context-Rich AI Agents

Cisco Open-Sources AI-BOM Scanner

Cisco open-sourced their AI-BOM (Bill of Materials) scanner and released a Model Provenance Kit - a "DNA test for AI models" to improve visibility and security against supply chain attacks.

Read more: AI News Briefs - July 2026

Community Guides & Articles

Building Multi-Agent Systems in Snowflake Cowork the Clean Way

Ranjeeta Pegu on building hierarchical agent systems using Snowflake-Managed MCP Servers instead of the complex UDF + REST API + PAT token approach. Wrap any Cortex Agent as an MCP tool for clean multi-agent orchestration.

Read more: Building Multi-Agent Systems in Snowflake Cowork: The Clean Way

Snowflake IaC with Terragrunt: Multi-Environment Design and CI/CD

Tatsuya Koreeda shares a comprehensive guide to Terraform + Terragrunt for Snowflake infrastructure - YAML-based resource definitions, state splitting, AI-assisted imports, and GitHub Actions CI/CD.

Read more: Snowflake IaC with Terragrunt

Video Content

GitHub: Community & Tools

SNACK-AI: The 2026 Pattern

As we look forward in 2026, SNACK-AI is the architectural pattern for powering AI applications at any scale - from mobile phones and robots to massive enterprise clusters.

SNACK-AI integrates:

  • Snowflake Platform
  • NiFi (Apache)
  • Apache Iceberg
  • Cortex AI (Agents/Search/MCP)
  • Kafka (Apache Kafka)

Deep Dive into SNACK-AI:

Thanks

https://sessionize.com/tspann
https://github.com/timothyspann

Issue #252 Generated with Cortex Code for All Data and AI Weekly - July 27, 2026

Top comments (0)