5 SQL window-function traps that show up in data engineering interviews (with runnable DuckDB examples)Default frames, ties, LAST_VALUE, filters before windows and sparse moving averages. Five small traps that separate knows SQL from writes correct pipelines.5 min read·itcraftsman.hashnode.devOct 12
Airflow 3 quietly changed what your cron schedule meansIn Airflow 3 a bare cron string no longer creates data intervals by default. Here is what changed, why your ds can shift by a day, and how to make your DAGs upgrade-proof.4 min read·itcraftsman.hashnode.devOct 12
