CH Data Tools — dbt + BigQuery Performance Pack (Team 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 engineering teams running dbt + BigQuery in production

- Teams tired of surprise BigQuery bills

- Organizations migrating to or evaluating BigQuery Editions

- Squads that need a shared, standardized optimization toolkit

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

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)

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

TEAM LICENSE (THIS PRODUCT)

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

- Up to 5 engineers in the same organization

- Shared internal repository allowed

- Unlimited professional projects

- Lifetime updates included

- No redistribution outside your organization

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

→ Organization-wide deployment? See the Company License ($999, unlimited engineers)

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

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.