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
Warehousing
Data warehousing: Snowflake, BigQuery, and cost control
Choosing, modeling, and tuning a warehouse — plus keeping the bill from outgrowing the value.
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
Business Health Dashboard Leaders Actually Open
A practitioner’s plan to build a business health dashboard that leadership actually uses—metrics, piping, dbt models, BI choices, weekly ritual, and failure modes.
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
Modern Data Stack for Startups: What You Need First
Stage-appropriate picks, plain-English tradeoffs, and real signals for when to add each layer of a modern data stack—without overspending or overbuilding.
10 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