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
dbt
dbt guides, patterns, and performance
Practical dbt writing from production engagements: modeling patterns, incremental strategies, testing, CI, and the refactors that cut runtimes.
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