Infrastructure
The dltHub REST API updated yesterday
No OpenAPI endpoint. So I unzipped the client library and diffed it.
Infrastructure
Posts related to platforms (usually hyperscalers), pipelines (ELT/rETL, streaming, orchestration) and agents
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.
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.
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
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.
Infrastructure
I needed 2,110 municipal contacts. So I built a crawler that refuses to guess.
A public contact list sounds easy... until 2,110 websites, four languages, changing staff, and source evidence get involved. 😅
Infrastructure
Backing up Microsoft Planner with dlt and Azure Blob
Microsoft Planner has no native backup export, so I built a declarative dlt job that writes complete Graph snapshots to Azure Blob. 😎