All Data and AI Weekly #249 - 06 July 2026
( AI, Data, Agentic AI, Cortex Code, NiFi, Iceberg, Polaris, Streamlit, Python, Java, SQL, MCP, LLM, RAG, Cortex AI, AIFN, Search, Unstructured Data )
Welcome to issue 249! This week brings a parade of post-Summit innovation. Snowflake engineering published on ArcticSwarm - a multi-agent system architecture for orchestrating AI agents at scale. Virtual Columns landed as an engineering deep dive on eliminating redundant storage. Composable Semantic Views entered limited access for modular semantic model design. Analytical Search entered public preview. Claude Sonnet 5 is now on Cortex AI. Snowflake Cowork launched as a personal work agent. Workload Identity Federation for external services went GA. Three Semantic View releases dropped: sample values, variables, and inline view GA. On the Apache side, NiFi 2 security enhancements and Flink Agents 0.3.0 shipped. The community delivered a comprehensive Summit feature summary, CI/CD with DCM Projects, Schemachange + Snowflake CLI, and a self-healing demo. I published three new repos - YOLOCamera, CoCoTracking, and SecurityWorkshop. Let's dig in!

- SNACKAI-CoCo-YOLOCamera - YOLO-based camera detection with Cortex Code (NEW)
- SNACKAI-CoCoTracking - Object tracking analytics with Cortex Code (NEW)
- SNACKAI-CoCo-SecurityWorkshop - Security workshop patterns with Cortex Code (NEW)
Video: Tim Spann at Summit 2026 - NiFi and Agents
- July 16: Powering Real-Time Analytics for APIs, Apps, and AI Agents - Virtual
- Snowflake Connect: Latest Innovations - Virtual
- AAIF: Applied AI Foundation - Conference
- AgentCon: Global AI Community AgentCon - Conference
Snowflake engineering introduces ArcticSwarm - a multi-agent system architecture for orchestrating AI agents at scale, enabling complex workflows through coordinated agent collaboration.
Read more: ArcticSwarm: Multi-Agent System Architecture
Engineering deep dive on Snowflake Virtual Columns - eliminating redundant storage and enabling computed columns that are materialized on-read.
Read more: Snowflake Virtual Columns
Claude Sonnet 5 is now available on Snowflake Cortex AI - Anthropic's latest model with enhanced reasoning, coding, and agentic capabilities.
Read more: Claude Sonnet 5 on Snowflake Cortex AI
Snowflake Cowork - a personal work agent that helps you get more done across your data workflows.
Read more: Snowflake Cowork: Personal Work Agent
Analytical Search enters public preview - natural language search across your analytical data.
Read more: https://docs.snowflake.com/en/release-notes/2026/other/2026-06-30-analytical-search-public-preview
Guide for building autonomous SQL pipelines that AI agents can create, execute, and manage.
Guide: https://www.snowflake.com/en/developers/guides/build-autonomous-sql-pipelines-for-ai-agents/
Self-healing demo - patterns for building self-healing data pipelines with Cortex Agents.
GitHub: https://github.com/sfc-gh-tbuchhorn/selfhealing-demo
Using Snowflake Cortex AI with AWS Bedrock as one unified agentic plane for all your data.
Reference gist for Cortex Code agent patterns.
Gist: https://gist.github.com/sfc-gh-vsekar/fd177a66a76128c94b1ba3f6d7338622
Composable Semantic Views - build modular, reusable semantic models by composing views from smaller building blocks.
Documentation: https://docs.snowflake.com/en/LIMITEDACCESS/composable-semantic-views
Define sample values for semantic view columns to help AI understand data patterns.
Read more: https://docs.snowflake.com/en/release-notes/2026/other/2026-06-25-semantic-views-sample-values
Variables in semantic views for parameterized, reusable metric definitions.
Read more: https://docs.snowflake.com/en/release-notes/2026/other/2026-06-26-semantic-views-variables
Inline views in semantic views are now GA.
Read more: https://docs.snowflake.com/en/release-notes/2026/other/2026-06-26-semantic-views-inline-view-ga
Workload Identity Federation for Snowflake workloads accessing external services is now GA.
Data Metric Function filter clause is now GA in BCR 2026-10_21.
Use Python directly in Snowflake Workspaces for data exploration and analysis.
Documentation: https://docs.snowflake.com/en/user-guide/ui-workspaces-python
Configure custom transformations for OpenFlow streaming connectors.
Documentation: https://docs.snowflake.com/en/user-guide/data-integration/openflow/connectors/streaming/configuring-custom-transformations
How Snowflake Workspaces eliminated the need to edit production Streamlit apps directly - proper dev/staging/prod workflows.
Deep dive on NiFi 2 security enhancements - improving security by removing legacy restrictions.
Apache Flink Agents 0.3.0 - new release for building AI agent workflows on streaming data.
Read more: https://flink.apache.org/2026/06/19/apache-flink-agents-0.3.0-release-announcement/
Hands-on guide for calling LLMs from Apache Flink for real-time AI inference on streams.
Read more: https://medium.com/@katyagorshkova/hands-on-with-flink-part-6-calling-llms-from-flink-e5cc7e5f0440
- Snowflake Summit 2026: Summary of New Features - Comprehensive feature summary from Summit
- From Inner Loop to Production: CI/CD with Snowflake DCM Projects - CI/CD pipeline patterns with DCM
- Snowflake + dbt + Airflow + Docker: Why This Stack Just Works - Modern data stack walkthrough
- Schemachange + Snowflake CLI - Database migration management
- Cortex AI + AWS Bedrock: One Agentic Plane - Unified agentic architecture
- We Stopped Editing Production Streamlit Apps - Workspaces for proper SDLC
- Summit: Data Pipelines Deep Dive
- Summit: AI & Agents Architecture
- Summit: Platform Innovation
- Summit: Cortex Code & Intelligence
- Summit: Iceberg & Polaris
- Summit: OpenFlow & Streaming
- Summit: Governance & Security
- New: ArcticSwarm Demo
- New: Virtual Columns Walkthrough
- New: Composable Semantic Views
- New: Analytical Search Preview
- New: Cowork Personal Agent
- New: Autonomous SQL Pipelines
- SNACKAI-CoCo-YOLOCamera - YOLO camera detection with Cortex Code
- SNACKAI-CoCoTracking - Object tracking analytics
- SNACKAI-CoCo-SecurityWorkshop - Security workshop patterns
- sfc-gh-tbuchhorn/selfhealing-demo - Self-healing pipeline demo
- AltimateAI/altimate-code - OWOX Model Canvas for data modeling
- jumpserver - Open source bastion host / jump server
- Faceplugin/Open-Source-Face-Recognition-SDK - Open source face recognition
- allenai/olmocr - Allen AI's open OCR toolkit
- ipcrawl.com - IP address intelligence platform
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)
- Read: SNACK-AI: The 2026 Pattern (Medium)
- Code: Official SNACK-AI GitHub Repository
- Weekly Context: SNACK-AI Overview
https://github.com/timothyspann
Generated with Cortex Code for All Data and AI Weekly - July 6, 2026
