📰 Dev.to · Philip Hern

a guide on using dbt snapshots to track slowly changing dimensions, including lessons learned from migrating away from custom merge strategies.

an exploration of how artificial intelligence is reshaping data engineering workflows, from automated pipelines to intelligent data modeling.

a practical guide on leveraging cursor and ai agents to automate the tedious parts of data engineering, specifically dbt tests and documentation.

a practical guide to dbt tests, with simple examples that catch common data issues before they leak into dashboards and downstream models

a practical guide to dbt docs, covering what they generate, how to write useful descriptions, doc blocks, persist_docs, and hosting on github pages

an informational primer on sql, including what it is, a short history, why it matters, and where to use it

a beginner-friendly guide for data engineers comparing snowflake to rds and nosql databases, covering scalability, use cases, and learning curves

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