Posts

This first edition covers the architecture of GammaVibe, text-to-code generated startup ideas, and key takeaways from Simon Willison's 'Year in LLMs'. We also explore Daniel Nettle's advice on maintaining a research career, data engineering predictions for 2026, the reality of analytics chatbot usage, and a handy data warehouse recommender tool by Aztela.

Some tools and techniques that help me do my job better.

Guide to automatically triage and fix failing GitHub Actions builds using GitHub Copilot’s coding agent. Walks through enabling the agent, creating a fine‑grained PAT, adding a workflow that opens issues and PRs, testing the setup, mobile review, and key security considerations, caveats, and costs.

Pragmatic tips learned migrating analytics from SAS Viya to Snowflake plus dbt. Compare capabilities, choose lift‑and‑shift vs remodeling, validate with dbt‑audit‑helper, debug flows, translate SAS logic to SQL, track dependencies, manage previews, scope data tests, handle true deletes and incremental logic, and preserve history with dbt snapshots.

Tutorial for free scheduled web scraping with GitHub Actions. Find a site’s JSON endpoint, then use curl and jq in a workflow to save data to the repo on a cron schedule. Explore results with Flat Viewer. Includes YAML, limits, and practical setup guidance.