BigQuery, bytes counted before you run.
BigQuery REST v2 and GoogleSQL with dry-run cost inspection, per-query cost ceilings, typed result paging, schema tooling, IAM plan review, and encrypted logical archives.
GoogleSQL · service account / ADC · emulator
The dry run Mongrel shows before you spend.
Click any stage below to see bytes processed, slot estimates, and what Mongrel would suggest. Same view you get inside the workbench.
// Dry Run · bytes processed
Validates the query and reports bytes billed without running it. 412.6 GB against a $0.20 ceiling — Mongrel blocks execution and shows the fix first.
-- analytics · project acme-prod SELECT DATE(e.event_ts) AS day, u.country, COUNT(*) AS events FROM analytics.events e JOIN analytics.dim_users u USING (user_id) WHERE e.event_type = 'purchase' GROUP BY day, country ORDER BY day DESC; -- dry run: 412.6 GB processed · blocked by $0.20 ceiling -- ✓ Proposal: partition filter + cluster on event_type WHERE _PARTITIONDATE >= '2026-07-01' AND e.event_type = 'purchase' -- dry run after fix: 8.4 GB · 98% fewer bytes
What Mongrel ships for BigQuery.
Visual GoogleSQL builder
Build SELECTs, JOINs, and window functions visually against live datasets. Output is real GoogleSQL — both sides stay editable.
Dry-run cost inspector
Run a dry run before every query. See bytes processed, on-demand price, and slot estimates before a single byte is scanned.
Cost ceilings
Set per-query maximum bytes billed and project-level budgets. Runaway scans are blocked at the workbench, not on the invoice.
Flexible authentication
Service account JSON, OAuth access token, or Application Default Credentials. Point at the BigQuery emulator for local development.
Typed result paging
Strongly typed rows over BigQuery REST v2 with page-token paging. INT64, NUMERIC, GEOGRAPHY, and STRUCT arrive as real types.
Data movement
Export query results and tables to CSV or JSON, load files into tables, and copy data between datasets, projects, or other engines.
Schema tooling & drift
Browse datasets, tables, and views with partition and clustering metadata. Compare schemas across projects and detect drift.
IAM plan review
Inspect dataset and table access, then preview IAM changes as reviewable plans before anything is applied to the project.
Encrypted logical archives
Snapshot table and query results into encrypted logical archives. Restore into BigQuery or any other supported engine later.