PinnedDave Flynndbt best practices in action at Cal-ITP’s data-infra projectCal-ITP uses a standardized PR template and automated report for comprehensive PR review. See their process in-action with example PRs8 min read·Apr 18, 2024----
Dave FlynnYou’re running dbt in CI, now what?PR schemas provide a data-airlock so that you have a safe space to check and validate your changes before merging to prod4 min read·2 days ago----
Dave Flynndbt Pull-Request Data Audit in GitHub Codespaces for FreeAudit any PR in your dbt data project with GitHub Codespaces following the write-audit-publish process7 min read·May 30, 2024----
Dave FlynnSelf-Serve Review for Self-Serve DataAnalysts need a way to perform self-serve review to validate their work, at the same time providing context to PR reviewers4 min read·May 23, 2024----
DouenergyFrom Zero to dbt: Part 2 — Modeling Spotify’s Million Playlist Datasetdbt helps us encapsulate logic within individual models and promotes a more structured and manageable development workflow12 min read·May 13, 2024----
DouenergyAnalytical SQL Tips Series — Lateral Column AliasSimplify your SQL by reusing expressions with Lateral Column Alias2 min read·May 10, 2024--1--1
Dave FlynnSpeed up pull request review for SQLMesh data projectsSQLMesh is a powerful ELT platform with features to help you iterate data pipelines with velocity. Do the same for your SQLMesh PR reviews!5 min read·May 9, 2024----
Dave FlynnAnnouncement: Recce now integrates with SQLMesh bringing enhanced data validation and PR reviewSQLMesh users can take advantage of the enhanced data validation and PR review tools in Recce to catch data issues before merging2 min read·May 7, 2024----
Dave Flynn‘Thoughtful PR Review’ is now a requirement for data jobsPR review is the ‘ Point of no Return’ — The last checkpoint before code is merged and prod data is changed. How do you review yours?5 min read·Apr 30, 2024----
DouenergyAnalytical SQL Tips Series —Qualify ClauseIn SQL, the QUALIFY clause is essential for filtering results from WINDOW functions, serving a similar purpose as the HAVING clause does…2 min read·Apr 19, 2024--2--2