Infrastructure
Asking small decision models (Jev + Laya) about first names
Thousands of contacts without salutation, and a model that has to guess from a first name alone.
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 😎
Infrastructure
Towards self-healing data pipelines: dltHub inspector in ❄️ Cortex
A Snowflake Cortex Agent for dltHub jobs
Infrastructure
Where dltHub's AI harness ends and Snowflake's CoCo begins
dltHub's AI harness writes the pipeline, Snowflake's CoCo takes over after data landed. Together they ✨
Infrastructure
The regexes had a good run
Hand-written patterns decided which Salesforce errors were noise. Now a classifier does it, and it says how sure it is.
Lakehouse
Making Sonnet 5 the CoCo default
Cortex Code's model default? Turns out it's just a CREATE AGENT statement away.
Lakehouse
Snowflake gave everyone 102 models and didn't tell me
200 users, zero curation, and a bootstrap grant I didn’t ask for.
Infrastructure
What if a dltHub pipeline fails without errors?
A watchdog to keep all dlt pipelines in line
Infrastructure
70 dlt pipelines, zero comments (and no alert when the schema changed)
Nobody documents dozens of tables with hundreds of columns by hand. So an agent does it, INFORMATION_SCHEMA keeps it honest, and Teams pings when a source API adds a column
Lakehouse
Snowflake data movement policies: the copy path gets a guardrail
Masking decides what you can see. Data movement policies decide what you can take.
Infrastructure
dltHub notifies Slack and email. But my org runs on Teams 😩
dltHub ships Slack and email alerts out of the box. My org runs on Teams, so I built the third one myself and wired it into all ~70 pipelines with one decorator shadow.
Infrastructure
7 shared modules for 27 dlt pipelines
Re-using shared patterns in a dlt workspace
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.