CH Data Tools — dbt + BigQuery Performance Pack (Company 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 platform teams standardizing dbt + BigQuery across the org

- Companies with multiple squads sharing a BigQuery billing account

- Organizations migrating to or evaluating BigQuery Editions at scale

- Engineering leadership that needs cost visibility and governance

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

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)

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

COMPANY LICENSE (THIS PRODUCT)

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

- Unlimited engineers in your organization

- CI/CD integration rights included

- Internal tooling and automation integration allowed

- Shared repositories across all teams

- Lifetime updates included

- No redistribution outside your organization

→ Just 1 engineer? See the Solo License ($199)

→ Small team (up to 5)? See the Team License ($499)

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

30-DAY MONEY-BACK GUARANTEE

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

If it doesn't save you time or money, email support@chdatatools.com for a full refund. No questions asked.

Not affiliated with Google or dbt Labs. All trademarks belong to their respective owners.