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
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
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.
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?”
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.
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
Finding Snowflake tasks that silently stopped running
Snowflake tasks are great... until one stops running and nobody notices.
Snowflake Cortex Code
Taking Snowflake Cortex Code for a spin
A simple first-party tracking approach
Own your data: A simple, almost-free first‑party tracking stack
Ad-hoc data visualization using Claude + MotherDuck + mviz
Ad-hoc analytics using Claude Code, MotherDuck and mviz to create visualizations
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 😎
Can you run dlt inside Snowflake? (Part 1/2: UDF)
So, dlt by dltHub runs "where Python runs"... I guess that means it should run in a Snowflake UDF, too. TL/DR: no, it doesn't 😎 But hey: negative results are results, too, right? 😅