Lakehouse

Infrastructure

LinkedIn Ads ➡️ Snowflake, with 3-legged OAuth in the middle

LinkedIn's Marketing API needs a browser to authorize. Scheduled pipelines don't have browsers. I store the refresh token in Snowflake.

Lakehouse

I migrated a Fivetran pipeline to dltHub for $0.65

One hour, five manual inputs, and $0.65 of tokens... enough to replace a daily Fivetran sync with a tested dltHub job

Lakehouse

Snowflake Iceberg in 2026: open format, now without the storage chores

Three Iceberg GAs in one week advancing the old tradeoff: open format without babysitting a bucket.

Lakehouse

MotherDuck Flights: pipelines an agent can fly, and why dlt belongs in the cockpit

MotherDuck shipped agent-native Python pipelines. The obvious thing to run inside one is dlt.

Lakehouse

How I Stopped ❄️ Cortex Agents from Auto-Picking the Expensive Model

How to configure Cortex Agent models for all agents at once

Lakehouse

Clippy: one Snowflake Cortex Agent, two faces

The paperclip is back. He works at Pro Juventute, lives in Snowflake, and shows up in both Teams and OpenCode.

Infrastructure

Triggering dltHub Pro pipelines from Snowflake

Moved a dlt pipeline off SPCS onto dltHub Pro. Still want Snowflake to push the button.

Infrastructure

dltHub Pro is here. So is my static-egress proxy VM.

How I kept IP‑locked Snowflake and Azure databases happy with a managed runtime that runs “wherever Python runs”

Infrastructure

Cortex Guardrails: one boolean, one job, four it doesn’t do

A single boolean on AI_COMPLETE, a Llama Guard 3 wrapper, and a hardcoded filter string. Useful, cheap, and nowhere near enough on its own.

Lakehouse

Cortex Code skills, 90 days in: plugins, not prompts

Cortex Code stopped being “just another AI feature” the moment skills landed. In under three months they’ve become the missing glue: portable, versioned building blocks that turn NPO data stacks into repeatable agent workflows.

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. 😎

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