Lakehouse

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 😎

Lakehouse

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? 😅