dbt Model Optimization: Fix the Models That Control Runtime
Your pipeline is late and the bill is up. This guide shows how to rank models by critical-path impact and compute cost, then apply exact fixes with SQL and configs.
7 min read
dbt
dbt guides, patterns, and performance
Practical dbt writing from production engagements: modeling patterns, incremental strategies, testing, CI, and the refactors that cut runtimes.
dbt Cloud Implementation: The Production Setup Checklist
A practitioner’s dbt Cloud implementation checklist: repo integration, environments, CI/state, jobs, access, docs, artifacts, alerts, and cost controls.
7 min read
dbt State-Aware Orchestration: What Changes in Prod
A practitioner’s guide to dbt state-aware orchestration in production: what it really runs, what breaks, how to measure savings, and how to roll out with guardrails.
7 min read
Redshift to Snowflake Migration: A Low‑Risk Cutover Plan
A practitioner’s plan to migrate from Redshift to Snowflake with minimal risk: inventory, data transfer and CDC, SQL/dbt gaps, security, BI cutover, reconciliation, and decommissioning.
5 min read
Implementing the dbt Semantic Layer Without Rebuilding Every Metric
A concrete migration plan to implement the dbt Semantic Layer without rewriting every metric: inventory, model entities and grains, define metrics, validate, secure, integrate, and roll out in stages.
10 min read
Snowflake Performance Tuning: Diagnose Before You Resize
A practitioner’s sequence to diagnose and fix slow queries in Snowflake—spills, pruning, joins, and concurrency—plus when to resize and how to prove it.
6 min read
Migrate Stored Procedures to dbt Without Changing Numbers
A practitioner’s playbook to migrate stored procedures to dbt without changing the numbers. Concrete patterns, code, validation, and a safe cutover plan.
4 min read
dbt Project Audit: What a Useful One Actually Covers
What a real dbt project audit includes, how to do it, and the artifacts you should get back—mapped to severity and a sequenced remediation plan.
7 min read
Data Warehouse Migration Planning That Won’t Stall
A practitioner’s program for migrating Redshift/Postgres to Snowflake or BigQuery—inventory, SQL translation, parallel-run reconciliation, cutover, and decommission.
8 min read
SQL Query Optimization for Columnar Warehouses
Triage and fix slow queries on Snowflake and BigQuery. Read profiles, prune data, control joins, avoid spill, and rewrite windows—backed by production patterns.
5 min read
Airflow + dbt: Run dbt From Airflow With Model-Level Visibility
A practitioner’s guide to running dbt from Airflow with model-level visibility. Compare Bash, dbt Cloud API, Cosmos, and Kubernetes—with real code and trade-offs.
9 min read
dbt Mesh: When to Split One Project into Many
When should you split one dbt repo into many? Concrete signals, what breaks in production, and a safe migration path—plus CI, contracts, and ownership.
7 min read
dbt Materializations: View, Table, Incremental, Ephemeral
A decision framework for dbt materializations that holds up in production: cost math, when views beat tables, incremental pitfalls, ephemeral tradeoffs, and safe swaps.
5 min read
dbt CI/CD That Catches Problems Before They Reach Prod
A complete dbt CI/CD pipeline that builds only what changed, isolates writes in a temporary schema, lints first, and blocks bad merges—plus real GitHub Actions YAML.
5 min read
dbt Cloud Pricing: What It Actually Costs in 2026
Seat vs. consumption costs, the real trade‑offs with self‑hosting, and a break‑even model you can plug your own numbers into—no fluff, just operator detail.
9 min read
Refactoring Legacy SQL in a dbt Project—Without Breaking Reports
Inherited a 600-model repo nobody understands? Here’s the operator’s playbook to refactor legacy SQL in dbt safely, prove parity, and keep BI stable.
4 min read
dbt Incremental Models: Strategies That Hold Up in Prod
A practitioner’s guide to dbt incremental models: when to use them, how to configure them, and how to avoid the production failures teams learn the hard way.
9 min read
dbt Cloud Migration: Move Without Breaking Production
A practitioner’s playbook to move from dbt-core on Airflow/cron to dbt Cloud with zero surprises: cost, fit, mapping, Slim CI, parity, cutover, and rollback.
5 min read
Snowflake Cost Optimization: Where the Credits Go
A practitioner’s guide to Snowflake cost optimization: attribute spend, fix warehouse settings, prune scans with clustering/MVs, and prevent regressions.
5 min read
dbt run slow? Why it happens and 7 fixes that work
If your dbt run is slow, start with the critical path: run_results.json, model timing, and the DAG’s longest chain. Then apply the seven fixes that actually pay off.
7 min read
Start a conversation
Tell us what's slowing your data team down.
We maintain a small client roster on purpose. If we're the wrong fit, we'll say so — and usually we know somebody who isn't.
- Replies within 2 business days
- NDA before specifics
- Fixed-scope first engagement, retainer if it works