Timothy Spann

Posted on Jun 22

All Data and AI Weekly #247-22 June 2026

#ai #data #dataengineering #news

All Data and AI Weekly #247 - 22 June 2026

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

Tim's Corner: Post-Summit Momentum - Adaptive Compute, Dynamic Tables, and Streaming at Scale

Welcome to issue 247! The post-Summit momentum continues this week with major GA announcements: Adaptive Compute is generally available, Dynamic Tables get faster and more flexible, Postgres Data Mirroring lands, and Snowpipe Streaming gets a deep-dive on real-time pipelines. The community delivered incredible content - from streaming 2.5 GB/s of connected vehicle data into Snowflake, to advanced multi-tenant semantic layer patterns, to best practices from a year of AI-augmented development with Cortex Code. On the AI side, Cortex Agent Tool Metrics gives visibility into agent behavior, Snowflake Cowork Artifacts are GA, and the Snowflake AI Kit now supports Claude Code. Plus new hands-on labs scheduled through August, Tim's Conf42 LLM talk on SQL automation, and a wealth of community repos. Let's dig in.

Tim's Content

Conf42 LLMs 2026 - SQL Automation & Operations

Tim's upcoming talk at Conf42 Large Language Models 2026 on SQL automation and operations with AI.

Session: SQL Automation Operations - Conf42 LLMs 2026

Summit 2026 Session Playlist

Full playlist from Snowflake Summit 2026 sessions:

Playlist: Snowflake Summit 2026 Sessions

Upcoming Events

June 23: Batch Data Extraction at Scale with Cortex AI Functions - Virtual Hands-On Lab
June 23: Power Your Agents with dbt and Snowflake - Virtual
June 24: From Raw Data to a Conversational AI Agent with Snowflake in 90 Minutes (KOP) - Virtual
June 25: Build Smarter: A Snowflake Hands-On Lab Day - In-Person
July 8: Getting Started with Cortex Code for Data Analysis (APAC) - Virtual Hands-On Lab
July 8: Snowflake Summit in 90 - India - Virtual
July 9: Build an Agent to Unlock Your Data in 90 Minutes - Virtual Hands-On Lab
July 22: Building Your First Multimodal Document Pipeline - Virtual Hands-On Lab
August 5: Create Context-Rich Agents Using Snowflake Intelligence and Cortex Knowledge Extensions - Virtual Hands-On Lab

AI Pulse - July 2026: Snowflake AI Pulse

Best of Summit 2026: Highlights & Replays

ETL with Snowflake Webinar (Astronomer): Watch Now

All Snowflake Events: snowflake.com/events

Snowflake Platform Updates & Blogs

Adaptive Compute - Generally Available

Adaptive Compute is now GA - automatically adjusts compute resources based on workload demands for optimal price-performance.

What's New in Dynamic Tables: Faster and More Flexible

Dynamic Tables get significant performance improvements and new flexibility for incremental materialization patterns.

Read more: What's New in Dynamic Tables

Postgres Data Mirroring

Mirror your PostgreSQL data directly into Snowflake - seamless replication without complex ETL.

Read more: Postgres Data Mirroring

Real-Time Pipelines with Snowpipe Streaming

Deep dive into building real-time data pipelines using Snowpipe Streaming for low-latency ingestion.

Snowflake Cowork Artifacts - GA (June 17)

Snowflake Cowork Artifacts are now generally available - share and version AI-generated artifacts across your team.

Documentation: Snowflake Cowork Artifacts

Release Notes: Cowork Artifacts GA

Cortex Agent Tool Metrics (June 11)

New tool-level metrics for Cortex Agents - gain visibility into how your agents use tools, latency, and success rates.

Release Notes: Cortex Agent Tool Metrics

Python Files in Workspaces - GA (June 18)

Python files in Workspaces are now generally available - develop and deploy Python directly in Snowflake workspaces.

Release Notes: Python Files in Workspaces GA

Streamlit Restricted Callers Rights - GA (June 1)

Streamlit restricted callers rights are now GA for tighter security control over Streamlit app permissions.

Release Notes: Streamlit Restricted Callers Rights GA

Integrated SaaS Listings - GA (June 30)

Integrated SaaS Listings are going GA - publish and discover SaaS applications directly in the Snowflake Marketplace.

Release Notes: Integrated SaaS Listings GA

Summit 2026 Release Notes Recap

Complete release notes from the June Summit announcements.

Release Notes: June Summit Release Notes

Migration Skill Documentation

Official documentation for the Snowflake Migration Skill for Cortex Code.

Documentation: Migration Skill

SPLIT_TO_TABLE Function Reference

SQL reference for the SPLIT_TO_TABLE function - split delimited strings into rows.

Documentation: SPLIT_TO_TABLE

Essential Guide: Transactional + Analytical Hybrid Data

Snowflake's guide to managing hybrid transactional and analytical data on a single platform.

eBook: Essential Guide to Hybrid Data

Cortex AI & Agents

Snowflake AI Kit - Claude Code Support

The Snowflake AI Kit now supports Claude Code for AI-assisted development workflows.

GitHub: Snowflake AI Kit - Claude Code

Add Guardrails to Your AI Agents with Hooks in Cortex Code CLI

Guide on adding guardrails with hooks in the Snowflake Cortex Code CLI for safer agent operations.

Snowflake and Anthropic Changed the Enterprise AI Game

Analysis of how the Snowflake + Anthropic partnership reshapes enterprise AI capabilities.

Best Practices from a Year of AI-Augmented Development with Cortex Code

Lessons learned from a full year of building with Cortex Code (CoCo) - workflows, patterns, and pitfalls.

Cortex Code Desktop dbt Panel

Deep dive into the dbt panel in Cortex Code Desktop for integrated dbt project management.

Read more: Cortex Code Desktop dbt Panel

Powering Claude Desktop with Cortex Inference

Connect Claude Desktop to Snowflake Cortex Inference for enterprise-governed AI interactions.

How to Set Up Snowflake MCP Servers with Per-User OAuth

Guide on configuring Snowflake MCP Servers with per-user OAuth authentication for secure multi-tenant agent access.

Snowflake CoCo for the Power BI Practitioner

Using Cortex Code as a Power BI practitioner - bridging BI workflows with AI-assisted development.

Read more: CoCo for the Power BI Practitioner

Data Engineering & Pipelines

Streaming 2.5 GB/s Connected Vehicle Data into Snowflake

The engineering behind ingesting 2.5 GB/s of connected vehicle telemetry into Snowflake in real-time.

What If You Could Skip the CDC Pipeline Entirely?

Exploring how to eliminate CDC complexity with Snowflake's native change tracking capabilities.

Read more: Skip the CDC Pipeline Entirely

Modernizing Snowflake ML Pipelines Without Rebuilding

Incrementally modernize ML pipelines on Snowflake without a full rewrite.

Snowflake Dashboards to Streamlit Migration

Step-by-step guide for migrating from Snowflake Dashboards to Streamlit apps.

Read more: Dashboards to Streamlit Migration

Postgres Data Movement & Interoperability

The New Stack on Postgres data movement patterns and interoperability with modern data platforms.

Check Every Row with One SQL Function

Using a single SQL function to validate every row in your dataset.

Semantic Layer & Identity

Advanced Patterns: Multi-Tenant Semantic Layers, Real-Time Metrics, Semantic Layer as API

Deep exploration of advanced semantic layer patterns - multi-tenancy, real-time metrics, and exposing the semantic layer as an API.

Read more: Advanced Semantic Layer Patterns

Snowflake: One Platform for Identity Resolution

Using Snowflake as a unified platform for first-party and partner identity resolution.

Apache Iceberg & Open Formats

Parquet Variant Shredding Specification

The official Variant Shredding specification for Apache Parquet - enabling efficient storage of semi-structured data in columnar format.

Spec: Parquet Variant Shredding

Summit 2026 Session Videos

From the Community: Medium & Blogs

Best Practices from a Year with Cortex Code - Lessons from AI-augmented development
Streaming 2.5 GB/s Vehicle Data - Engineering at extreme ingest scale
Advanced Semantic Layer Patterns - Multi-tenant, real-time, and API patterns
Snowflake + Anthropic: Enterprise AI - Partnership impact analysis
Guardrails with Hooks in Cortex Code CLI - Agent safety patterns
Skip the CDC Pipeline Entirely - Eliminating CDC complexity
Cortex Code Desktop dbt Panel - dbt integration deep dive
Powering Claude Desktop with Cortex Inference - Enterprise AI on your desktop
Snowflake MCP Servers with Per-User OAuth - Secure multi-tenant agents
CoCo for the Power BI Practitioner - Bridging BI and AI
Modernizing ML Pipelines Without Rebuilding - Incremental modernization
Dashboards to Streamlit Migration - Migration guide
Identity Resolution on One Platform - First-party and partner resolution
Check Every Row with One SQL Function - Row-level validation

GitHub: Community & Tools

Snowflake-Labs/snowflake-ai-kit - Snowflake AI Kit with Claude Code support
omnigent-ai/omnigent - Open-source multi-agent framework
cauenapier/TownSquare - Community collaboration platform
spronta/crawlie - Web crawler for data collection
OpenCut-app/OpenCut - Open-source video editor
likec4/likec4 - Architecture diagrams as code
YusufB5/ASCILINE - ASCII art pipeline visualizer
rxi/microui - Tiny immediate-mode UI library in C
apache/parquet-format - Parquet Variant Shredding spec

AI & LLM Tools

google/gemma-4-26b-a4b on LM Studio - Google Gemma 4 26B model for local inference
agenticresourcediscovery.org - Agentic Resource Discovery standard

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: