Lakehouse
Retiring legacy BI with an agentic-built Streamlit app on SPCS
Build-vs-buy got rewritten by agentic coding. So I retired the legacy BI tool. 😎
Martin Seifert
Strategy, engineering, privacy, modeling, visualization, analysis, ML, AI. Sprinkle some product ownership on top and you got a jack-of-all-trades decision-enabler 😎
Lakehouse
Exporting Snowflake data to Excel
Generate XLSX files directly from Snowflake using a small Snowpark stored procedure, writing straight to a stage so stakeholders get ready-to-use Excel workbooks without any CSV exports or manual conversions
Lakehouse
Snowflake interactive warehouses: cheaper, always-warm, and yes, the SQL API works
Snowflake’s interactive warehouses sit in a sweet spot for user-facing workloads: they cost 60% of a same-sized standard warehouse, can stay warm across business hours, and still serve sub‑second lookups from an interactive table
Infrastructure
Two AI agents, one repo: delegating Snowflake work from Claude Code to Cortex Code
Claude Code and Snowflake's Cortex Code turn out to be the same agent wearing different hats - and that's exactly what makes them worth combining. A filesystem handoff between two AI agents replaced hours of manual Snowsight clicking.
Lakehouse
Snowflake Intelligence on Snowflake Cost: let the platform watch itself
Snowflake’s ACCOUNT_USAGE is powerful but often too complex. I built a cost analyst with Snowflake Intelligence: 19+ views merged into 6 tables, 25 billing rules, enabling questions like “why did costs spike?”
Lakehouse
Reverse-Engineering a Black-Box ERP with Claude Code
Using dlt’s AI workbench and Claude Code, I reverse‑engineered our ERP's undocumented 1,200+ table schema and produced an annotated DBML model plus ontology.
Lakehouse
A PII-safe web search tool for Snowflake agents
A PII-safe alternative to Brave web search for Snowflake Cortex Agents, using Perplexity and AI_REDACT
Lakehouse
Finding Snowflake tasks that silently stopped running
Snowflake tasks are great... until one stops running and nobody notices.
Lakehouse
Snowflake Cortex Code
Taking Snowflake Cortex Code for a spin
Digital Analytics
A simple first-party tracking approach
Own your data: A simple, almost-free first‑party tracking stack
Lakehouse
Ad-hoc data visualization using Claude + MotherDuck + mviz
Ad-hoc analytics using Claude Code, MotherDuck and mviz to create visualizations
Lakehouse
Can you run dlt inside Snowflake? (Part 2/2: SPCS)
In my last post I explored whether dlt could run in a Snowflake UDF... and failed. But can it still run inside Snowflake using a Container? TL/DR: yes, it does 😎