MWAA Migration: Move Apache Airflow Without Relearning Lessons
An operator’s MWAA migration plan—what moves as‑is, what to redesign, exact checks, and a parallel‑run cutover with rollback. Use it in‑house or bring us in.
7 min read
Warehousing
Data warehousing: Snowflake, BigQuery, and cost control
Choosing, modeling, and tuning a warehouse — plus keeping the bill from outgrowing the value.
Executive Dashboard Consulting: Deliverables That Work
A practitioner’s guide to scoping, building, and rolling out an executive dashboard that leadership trusts—definitions first, charts second.
9 min read
Data Warehouse Cost Allocation by Team, Product, Workload
A practical path from an opaque warehouse bill to a defensible cost ledger. Concrete Snowflake and BigQuery patterns, tags, roles, reservations, and showback/chargeback.
6 min read
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
Snowflake Cortex Analyst: Production Readiness Beyond the Demo
A practitioner’s guide to making Cortex Analyst reliable: semantic model design, verified queries, ambiguity handling, evaluation and rollout, and cost controls.
9 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
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
Snowflake Cortex Cost: Model It Before You Scale
Your Cortex bill spiked or you’re about to roll it out. Here’s the fastest diagnostic and a practical cost model—tokens, serverless services, and warehouse compute—plus guardrails.
5 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
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