philliant
a polyerudite notebook by philip mathew hern
current writing
latest essay
notes on learning the streaming side of the warehouse
i am in the middle of debezium and kafka work that does not fit in my head the way sql does, so i wrote down what each piece is for and how they connect from source system to analytics
·7 mins
featured book
AI-Assisted Data Engineering
A senior engineer's playbook for building real dbt and Snowflake data products with AI agents, released one chapter at a time.
explore by topic
all series →ai
practical notes on ai workflows, decision quality, and sustainable usage
explore →data vault 2.0
hands-on patterns for hubs, links, satellites, and evolvable warehouse design
explore →dbt
modeling, testing, and maintainable transformation workflows with dbt
explore →sql
query patterns, debugging habits, and practical sql work across projects
explore →recent writing
all posts →
as-of is not the same as current
a lot of warehouse bugs come from answering the wrong time question. i explain when you need an as-of result instead of the current row, and three patterns that keep the grain correct.

continuity
i want to keep putting in work on this website, but continuity is not the same as continuous. a long break is not quitting if i pick back up where i left off, and sometimes good ideas and renewed motivation come from the space in between.

a polyerudite notebook
i want more flexibility on this site because my interests are wide and they change all the time. work stays on the menu when something comes up.
