CH Data Tools — dbt + BigQuery Performance Pack (Solo License)

Stop overpaying for BigQuery. Start shipping faster with dbt.

Production-ready code you drop into your dbt project today — not a course, not a video series. Just macros, queries, and playbooks built for real pipelines.

────────────────────────────────────────

THE PROBLEM THIS SOLVES

────────────────────────────────────────

- Accidental full-table scans inflating your BigQuery bill

- Incremental models that silently create duplicates on MERGE

- No visibility into which dbt runs cost the most

- Guessing whether BigQuery Editions would actually save money

- Hours spent writing monitoring queries from scratch

────────────────────────────────────────

WHAT YOU GET (INSTANT DOWNLOAD — 68 FILES)

────────────────────────────────────────

✅ 6 deep playbooks — hands-on guides with real code + decision frameworks

✅ 18 dbt macros (20 callable definitions) — installable as a dbt package

✅ 18 BigQuery analysis queries — cost diagnostics + pipeline monitoring, one per file

✅ 30 SQL snippets — drop-in patterns for partitioning, clustering, incremental, and testing

✅ Python benchmark harness — measure bytes scanned & runtime before/after any change

✅ Editions calculator — model Standard vs Enterprise vs on-demand cost tradeoffs

✅ Cheat sheet (1-page reference) + quickstart guide (running in 10 minutes)

────────────────────────────────────────

BUILT FOR

────────────────────────────────────────

- Data engineers running dbt + BigQuery in production

- Teams tired of surprise BigQuery bills

- Anyone migrating to or evaluating BigQuery Editions

- Solo practitioners and consultants who bill for optimization work

────────────────────────────────────────

REQUIREMENTS

────────────────────────────────────────

- dbt-core >= 1.6 with dbt-bigquery >= 1.6

- BigQuery Standard SQL (on-demand or Editions)

- Python >= 3.9 (optional — only for benchmark/calculator scripts)

────────────────────────────────────────

SOLO LICENSE (THIS PRODUCT)

────────────────────────────────────────

- 1 engineer (single user)

- Unlimited personal + professional projects

- Lifetime updates included

- No redistribution, resale, or public sharing

→ Need a shared repo? See the Team License ($499, up to 5 engineers)

→ Organization-wide? See the Company License (