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 FlynnIdentify and Automate Data Checks on Critical dbt ModelsDo you know which are the critical models in your data project? Business critical models or possible breakpoints need to be checked every…5 min read·2 days ago----
Dave FlynnHow to use a Makefile to speed up your dbt project workflowLearn how to use a makefile to reduce dbt command fatigue and group related commands for easy reuse and sharing.5 min read·Jun 13, 2024--2--2
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·Jun 7, 2024--1--1
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----