✕ Clear all filters
19 articles
▶ Videos →

📰 Dev.to · Philip Hern

19 articles · Updated every 3 hours · View all reads

All Articles 188,230Blog Posts 170,395Tech Tutorials 50,366Research Papers 36,763News 23,117 ⚡ AI Lessons
chapter 2 of ai-assisted data engineering is live
Dev.to · Philip Hern 🤖 AI Agents & Automation ⚡ AI Lesson 2mo ago
chapter 2 of ai-assisted data engineering is live
announcing chapter 2 of ai-assisted data engineering, the danger of trusting the agent, the darker companion to earned judgment and the ownership habits that ke
philliant on youtube is the companion to the writing
Dev.to · Philip Hern 🤖 AI Agents & Automation ⚡ AI Lesson 2mo ago
philliant on youtube is the companion to the writing
announcing philliant on youtube, the channel that will sit beside philliant.com, with videos talking through the posts, ai-assisted data engineering, and the id
room to breathe
Dev.to · Philip Hern 🤖 AI Agents & Automation ⚡ AI Lesson 3mo ago
room to breathe
why ai makes it feel like you can always do a little more, and why you still need room to breathe when you, not the model, are the one who has to review, unders
the guardrails i actually use with ai agents
Dev.to · Philip Hern 🤖 AI Agents & Automation ⚡ AI Lesson 3mo ago
the guardrails i actually use with ai agents
the concrete guardrails i put around ai coding agents, including read-only and ask modes, command allowlists, scoped database credentials, branch protection, an
dynamic tables, where have you been all my life?
Dev.to · Philip Hern 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
dynamic tables, where have you been all my life?
how snowflake dynamic tables provide a declarative, join-supporting alternative to traditional task orchestration and materialized views
keep your snapshots simple
Dev.to · Philip Hern 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4mo ago
keep your snapshots simple
snapshots are powerful but expensive. use them only when absolutely necessary, never stack them on top of each other, and let the rest of your warehouse stay de
back at it
Dev.to · Philip Hern 📅 Project Management ⚡ AI Lesson 5mo ago
back at it
a short note on getting through a heavy lift by staying with the problem, working in smaller chunks, and reaching a stable enough place to breathe before the ne
dbt snapshots: moving from merges to native history
Dev.to · Philip Hern 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5mo ago
dbt snapshots: moving from merges to native history
a guide on using dbt snapshots to track slowly changing dimensions, including lessons learned from migrating away from custom merge strategies.
the future of data engineering workflows with ai
Dev.to · Philip Hern 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5mo ago
the future of data engineering workflows with ai
an exploration of how artificial intelligence is reshaping data engineering workflows, from automated pipelines to intelligent data modeling.
how i use cursor and ai agents to write dbt tests and documentation
Dev.to · Philip Hern 🤖 AI Agents & Automation ⚡ AI Lesson 5mo ago
how i use cursor and ai agents to write dbt tests and documentation
a practical guide on leveraging cursor and ai agents to automate the tedious parts of data engineering, specifically dbt tests and documentation.
dbt tests
Dev.to · Philip Hern 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5mo ago
dbt tests
a practical guide to dbt tests, with simple examples that catch common data issues before they leak into dashboards and downstream models
dbt docs
Dev.to · Philip Hern 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5mo ago
dbt docs
a practical guide to dbt docs, covering what they generate, how to write useful descriptions, doc blocks, persist_docs, and hosting on github pages
what is sql, and why it still works
Dev.to · Philip Hern 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6mo ago
what is sql, and why it still works
an informational primer on sql, including what it is, a short history, why it matters, and where to use it
the difference between snowflake and the "other" databases
Dev.to · Philip Hern 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6mo ago
the difference between snowflake and the "other" databases
a beginner-friendly guide for data engineers comparing snowflake to rds and nosql databases, covering scalability, use cases, and learning curves
left join an effective satellite without duplicating rows (use a cte)
Dev.to · Philip Hern 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6mo ago
left join an effective satellite without duplicating rows (use a cte)
a small data vault 2.0 sql pattern: pre-filter the effective satellite in a cte, then left join the cte so optional links do not multiply grain